DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on WSM_SPLIT_MERGE_TRANSACTIONS_S

Line 1725: SELECT wsm_split_merge_transactions_s.NEXTVAL

1721: WHERE assembly_item_id = l_prev_inventory_item_id
1722: AND organization_id = p_org_id
1723: AND ((ALTERNATE_ROUTING_DESIGNATOR = p_hdr_rec.alt_routing_designator) OR (ALTERNATE_ROUTING_DESIGNATOR IS NULL));
1724:
1725: SELECT wsm_split_merge_transactions_s.NEXTVAL
1726: INTO l_trx_id
1727: FROM DUAL;
1728:
1729: SELECT wsm_split_merge_transactions_s.NEXTVAL

Line 1729: SELECT wsm_split_merge_transactions_s.NEXTVAL

1725: SELECT wsm_split_merge_transactions_s.NEXTVAL
1726: INTO l_trx_id
1727: FROM DUAL;
1728:
1729: SELECT wsm_split_merge_transactions_s.NEXTVAL
1730: INTO l_source_line_id
1731: FROM DUAL;
1732:
1733: IF (g_debug_level <= 1) THEN

Line 2067: SELECT wsm_split_merge_transactions_s.NEXTVAL

2063: SELECT wsm_sm_txn_interface_s.NEXTVAL
2064: INTO l_header_id
2065: FROM DUAL;
2066:
2067: SELECT wsm_split_merge_transactions_s.NEXTVAL
2068: INTO l_trx_id
2069: FROM DUAL;
2070:
2071: SAVEPOINT before_insert;