1478: p_start_txn_date IN DATE DEFAULT NULL,
1479: p_end_txn_date IN DATE DEFAULT NULL
1480: )
1481: IS
1482: l_wip_transaction_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1483: l_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1484: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1485: l_operation_seq_nums JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1486: l_transaction_uoms JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1479: p_end_txn_date IN DATE DEFAULT NULL
1480: )
1481: IS
1482: l_wip_transaction_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1483: l_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1484: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1485: l_operation_seq_nums JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1486: l_transaction_uoms JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1487: BEGIN
1480: )
1481: IS
1482: l_wip_transaction_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1483: l_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1484: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1485: l_operation_seq_nums JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1486: l_transaction_uoms JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1487: BEGIN
1488: IF p_repair_line_id IS NOT NULL
1481: IS
1482: l_wip_transaction_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1483: l_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1484: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1485: l_operation_seq_nums JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1486: l_transaction_uoms JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1487: BEGIN
1488: IF p_repair_line_id IS NOT NULL
1489: THEN
2281: l_trans_count NUMBER;
2282: l_return_count NUMBER;
2283: --subhat, FedEx material updates changes.
2284: -- swai: bug 13820264, FP of bug#13797285, subhat
2285: l_wip_entity_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2286: BEGIN
2287: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2288: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
2289: lc_mod_name||'begin',
9866: IS
9867: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_DELETE_OP_DTL';
9868: lc_api_version_number CONSTANT NUMBER := 1.0;
9869: lc_mod_name CONSTANT VARCHAR2(60) := 'csd.plsql.csd_hv_wip_job_pvt.update_mat_issue_quantities';
9870: l_transaction_type_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9871: l_transaction_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9872: l_wip_transaction_detail_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9873:
9874: l_all_jobs sys_refcursor;
9867: lc_api_name CONSTANT VARCHAR2(30) := 'PROCESS_DELETE_OP_DTL';
9868: lc_api_version_number CONSTANT NUMBER := 1.0;
9869: lc_mod_name CONSTANT VARCHAR2(60) := 'csd.plsql.csd_hv_wip_job_pvt.update_mat_issue_quantities';
9870: l_transaction_type_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9871: l_transaction_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9872: l_wip_transaction_detail_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9873:
9874: l_all_jobs sys_refcursor;
9875:
9868: lc_api_version_number CONSTANT NUMBER := 1.0;
9869: lc_mod_name CONSTANT VARCHAR2(60) := 'csd.plsql.csd_hv_wip_job_pvt.update_mat_issue_quantities';
9870: l_transaction_type_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9871: l_transaction_quantities JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9872: l_wip_transaction_detail_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
9873:
9874: l_all_jobs sys_refcursor;
9875:
9876: