0 Replies Latest reply: Nov 26, 2012 10:04 PM by Kvsk-Oracle RSS

    How is p_copy_entity_txn_id generated in the code.

    Kvsk-Oracle
      I am trying to replicate 'Plan Design Copy' Self-Service process into a concurrent program.

      Responsibility : US HRMS Manager
      Navigation : Total Compensation : Programs and Plans > Plan Design Copy
      copy or export plan design
      - specify process name and effective date
      - click next ..and so-on

      What I could find is these steps will submit one concurrent program 'Copy Plan Design Process' (executable = ben_plan_design_copy_process) with p_copy_entity_txn_id and other parameters passed to it.

      My Question is about p_copy_entity_txn_id, which gets generated the moment we click next for the first time in below series of steps :

      Navigation : Total Compensation : Programs and Plans > Plan Design Copy
      copy or export plan design
      - specify process name and effective date
      - click next..

      I could notice that this process hits two tables
      pqh_copy_entity_txns
      pqh_copy_entity_attribs

      I need help to identify what logic is used to generate this id : p_copy_entity_txn_id
      and how I should go about it.