eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CSP_REQ_LINES_ACC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33


   SELECT RH.resource_id
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RL.REQUIREMENT_LINE_ID = b_req_line_id;

Line: 40


   SELECT jta.resource_id
   FROM   jtf.jtf_task_assignments jta
   ,      csp_requirement_headers crh
   ,      csp_requirement_lines crl
   WHERE  crh.task_assignment_id = jta.task_assignment_id
   AND    jta.assignee_role = 'ASSIGNEE'
   AND    crh.requirement_header_id = crl.requirement_header_id
   AND    crl.requirement_line_id = b_req_line_id;*/

Line: 115


PROCEDURE Insert_ACC_Record
  ( p_req_line_id        IN NUMBER
  )
IS
  CURSOR c_req_info (b_req_line_id NUMBER) IS
   SELECT RH.resource_id
   ,      OH.HEADER_ID
   ,      OL.LINE_ID
   ,      RH.DESTINATION_ORGANIZATION_ID
   ,      RL.INVENTORY_ITEM_ID
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   ,      OE_ORDER_LINES_ALL      OL
   ,      OE_ORDER_HEADERS_ALL    OH
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RL.REQUIREMENT_LINE_ID   = b_req_line_id
   AND    RL.ORDER_LINE_ID         = OL.LINE_ID (+)
   AND    OL.HEADER_ID             = OH.HEADER_ID (+);

Line: 137


   SELECT jta.resource_id
   ,      oh.header_id
   ,      ol.line_id
   FROM   jtf.jtf_task_assignments jta
   ,      csp_requirement_headers crh
   ,      csp_requirement_lines crl
   ,      oe_order_headers_all oh
   ,      oe_order_lines_all ol
   WHERE  crh.task_assignment_id = jta.task_assignment_id
   AND    jta.assignee_role = 'ASSIGNEE'
   AND    crh.requirement_header_id = crl.requirement_header_id
   AND    crl.requirement_line_id = b_req_line_id
   AND    crl.order_line_id = ol.line_id(+)
   AND    ol.header_id = oh.header_id(+);*/

Line: 162


    , 'Entering Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 170


    , 'Inserting ACC record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 208


      csl_mtl_system_items_acc_pkg.pre_insert_child(
        r_req_info.inventory_item_id
       ,r_req_info.destination_organization_id
       ,l_resource_id);

Line: 214


    JTM_HOOK_UTIL_PKG.Insert_Acc
    (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name
     , P_ACC_TABLE_NAME         => g_acc_table_name
     , P_PK1_NAME               => g_pk1_name
     , P_PK1_NUM_VALUE          => p_req_line_id
     , P_RESOURCE_ID            => l_resource_id
    );

Line: 224


      JTM_HOOK_UTIL_PKG.Insert_Acc
      (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
       , P_ACC_TABLE_NAME         => g_acc_table_name1
       , P_PK1_NAME               => g_pk1_name1
       , P_PK1_NUM_VALUE          => l_header_id
       , P_RESOURCE_ID            => l_resource_id
      );

Line: 232


      JTM_HOOK_UTIL_PKG.Insert_Acc
      (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
       , P_ACC_TABLE_NAME         => g_acc_table_name2
       , P_PK1_NAME               => g_pk1_name2
       , P_PK1_NUM_VALUE          => l_line_id
       , P_RESOURCE_ID            => l_resource_id
      );

Line: 246


    , 'Leaving Insert_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 249


END Insert_ACC_Record;

Line: 252


PROCEDURE Update_ACC_Record
  ( p_req_line_id        IN NUMBER
  )
IS
  CURSOR c_req_info (b_req_line_id NUMBER) IS
   SELECT RH.resource_id
   ,      OH.HEADER_ID
   ,      OL.LINE_ID
   ,      RH.DESTINATION_ORGANIZATION_ID
   ,      RL.INVENTORY_ITEM_ID
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   ,      OE_ORDER_LINES_ALL      OL
   ,      OE_ORDER_HEADERS_ALL    OH
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RL.REQUIREMENT_LINE_ID   = b_req_line_id
   AND    RL.ORDER_LINE_ID         = OL.LINE_ID (+)
   AND    OL.HEADER_ID             = OH.HEADER_ID (+);

Line: 274


   SELECT jta.resource_id
   ,      oh.header_id
   ,      ol.line_id
   FROM   jtf.jtf_task_assignments jta
   ,      csp_requirement_headers crh
   ,      csp_requirement_lines crl
   ,      oe_order_headers_all oh
   ,      oe_order_lines_all ol
   WHERE  crh.task_assignment_id = jta.task_assignment_id
   AND    jta.assignee_role = 'ASSIGNEE'
   AND    crh.requirement_header_id = crl.requirement_header_id
   AND    crl.requirement_line_id = b_req_line_id
   AND    crl.order_line_id = ol.line_id(+)
   AND    ol.header_id = oh.header_id(+);*/

Line: 299


    , 'Entering Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 337


      , 'Update ACC Record error: Could not find resource for requirement line '|| p_req_line_id
      , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line: 345


      csl_mtl_system_items_acc_pkg.pre_insert_child(
        r_req_info.inventory_item_id
       ,r_req_info.destination_organization_id
       ,l_resource_id);

Line: 351


    JTM_HOOK_UTIL_PKG.Update_Acc
     ( g_publication_item_name
      ,g_acc_table_name
      ,l_resource_id
      ,p_req_line_id
     );

Line: 360


      JTM_HOOK_UTIL_PKG.Insert_Acc
      (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
       , P_ACC_TABLE_NAME         => g_acc_table_name1
       , P_PK1_NAME               => g_pk1_name1
       , P_PK1_NUM_VALUE          => l_header_id
       , P_RESOURCE_ID            => l_resource_id
      );

Line: 368


      JTM_HOOK_UTIL_PKG.Insert_Acc
      (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
       , P_ACC_TABLE_NAME         => g_acc_table_name2
       , P_PK1_NAME               => g_pk1_name2
       , P_PK1_NUM_VALUE          => l_line_id
       , P_RESOURCE_ID            => l_resource_id
      );

Line: 382


    , 'Leaving Update_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 385


END Update_ACC_Record;

Line: 387


/*** Private procedure that deletes requirement for resource from acc table ***/
PROCEDURE Delete_ACC_Record
  ( p_req_line_id IN NUMBER
   ,p_resource_id        IN NUMBER
  )
IS
  CURSOR c_req_line_id (b_req_line_id NUMBER) IS
   SELECT RH.resource_id
   ,      OH.HEADER_ID
   ,      OL.LINE_ID
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   ,      OE_ORDER_LINES_ALL      OL
   ,      OE_ORDER_HEADERS_ALL    OH
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RL.REQUIREMENT_LINE_ID   = b_req_line_id
   AND    RL.ORDER_LINE_ID         = OL.LINE_ID (+)
   AND    OL.HEADER_ID             = OH.HEADER_ID (+);

Line: 416


    , 'Entering Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 441


    JTM_HOOK_UTIL_PKG.Delete_Acc
     (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name
      , P_ACC_TABLE_NAME         => g_acc_table_name
      , P_PK1_NAME               => g_pk1_name
      , P_PK1_NUM_VALUE          => p_req_line_id
      , P_RESOURCE_ID            => p_resource_id
     );

Line: 457


        , 'Delete Order Header acc record for user: ' || p_resource_id
        , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 460


      JTM_HOOK_UTIL_PKG.Delete_Acc
       (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
        , P_ACC_TABLE_NAME         => g_acc_table_name1
        , P_PK1_NAME               => g_pk1_name1
        , P_PK1_NUM_VALUE          => l_header_id
        , P_RESOURCE_ID            => p_resource_id
       );

Line: 472


        , 'Delete Order Line acc record for user: ' || p_resource_id
        , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 475


      JTM_HOOK_UTIL_PKG.Delete_Acc
       (  P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
        , P_ACC_TABLE_NAME         => g_acc_table_name2
        , P_PK1_NAME               => g_pk1_name2
        , P_PK1_NUM_VALUE          => l_line_id
        , P_RESOURCE_ID            => p_resource_id
       );

Line: 490


    , 'Leaving Delete_ACC_Record'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 493


END Delete_ACC_Record;

Line: 495


/*** Called before requirement Insert ***/
PROCEDURE PRE_INSERT_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 502


END PRE_INSERT_REQ_LINE;

Line: 504


/*** Called after requirement Insert ***/
PROCEDURE POST_INSERT_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
  l_req_line_id        NUMBER;

Line: 523


    , 'Entering POST_INSERT hook'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 530


  /*** Insert record if applicable ***/
  IF Replicate_Record(l_req_line_id) THEN
    Insert_ACC_Record(l_req_line_id);

Line: 539


    , 'Leaving POST_INSERT hook'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 552


    , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line: 555


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_INSERT_REQ_LINE',sqlerrm);

Line: 558


END POST_INSERT_REQ_LINE;

Line: 560


/* Called before requirement Update */
PROCEDURE PRE_UPDATE_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 570


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','PRE_UPDATE_REQ_LINE',sqlerrm);

Line: 573


END PRE_UPDATE_REQ_LINE;

Line: 575


/* Called after requirement Update */
PROCEDURE POST_UPDATE_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
  l_req_line_id        NUMBER;

Line: 595


    , 'Entering POST_UPDATE hook'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 603


    Update_ACC_Record(l_req_line_id);

Line: 610


    , 'Leaving POST_UPDATE hook'
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 621


    , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line: 624


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_UPDATE_REQ_LINE',sqlerrm);

Line: 627


END POST_UPDATE_REQ_LINE;

Line: 629


/* Called before req header Delete */
PROCEDURE PRE_DELETE_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 636


END PRE_DELETE_REQ_LINE;

Line: 638


/* Called after req header Delete */
PROCEDURE POST_DELETE_REQ_LINE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN

  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 649


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','POST_DELETE_REQ_LINE',sqlerrm);

Line: 652


END POST_DELETE_REQ_LINE;

Line: 657


PROCEDURE Delete_All_ACC_Records
  ( p_resource_id in NUMBER
  , x_return_status OUT NOCOPY varchar2
  )
IS
 CURSOR c_req_resource (b_resource_id NUMBER) IS
   SELECT RL.REQUIREMENT_LINE_ID
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RH.RESOURCE_ID = b_resource_id;

Line: 670


   SELECT crl.requirement_line_id
   FROM   jtf.jtf_task_assignments jta
   ,      csp_requirement_headers crh
   ,      csp_requirement_lines crl
   WHERE  crh.task_assignment_id = jta.task_assignment_id
   AND    jta.assignee_role = 'ASSIGNEE'
   AND    crh.requirement_header_id = crl.requirement_header_id
   AND    jta.resource_id = b_resource_id;*/

Line: 685


    , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 691


    Delete_Acc_Record( r_req_resource.requirement_line_id, p_resource_id );

Line: 703


    , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 711


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Delete_All_ACC_Records',sqlerrm);

Line: 714


END Delete_All_ACC_Records;

Line: 717


PROCEDURE Insert_All_ACC_Records
  ( p_resource_id in NUMBER
  , x_return_status OUT NOCOPY varchar2
  )
IS
 CURSOR c_req_resource (b_resource_id NUMBER) IS
   SELECT RL.REQUIREMENT_LINE_ID
   FROM   CSP_REQUIREMENT_HEADERS RH
   ,      CSP_REQUIREMENT_LINES   RL
   WHERE  RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
   AND    RH.RESOURCE_ID = b_resource_id;

Line: 730


   SELECT crl.requirement_line_id
   FROM   jtf.jtf_task_assignments jta
   ,      csp_requirement_headers crh
   ,      csp_requirement_lines crl
   WHERE  crh.task_assignment_id = jta.task_assignment_id
   AND    jta.assignee_role = 'ASSIGNEE'
   AND    crh.requirement_header_id = crl.requirement_header_id
   AND    jta.resource_id = b_resource_id;*/

Line: 745


    , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 752


      Insert_Acc_Record( r_req_resource.requirement_line_id );

Line: 767


    , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
    , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line: 774


  fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_LINES_ACC_PKG','Insert_All_ACC_Records',sqlerrm);

Line: 777


END Insert_All_ACC_Records;