APPS.M4R_7B1_WSM_IN dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 2080: INTO WSM_SPLIT_MERGE_TXN_INTERFACE ( HEADER_ID,

2076: cln_debug_pub.Add('l_trx_id : ' || l_trx_id, 2);
2077: END IF;
2078:
2079: INSERT
2080: INTO WSM_SPLIT_MERGE_TXN_INTERFACE ( HEADER_ID,
2081: TRANSACTION_TYPE_ID,
2082: TRANSACTION_DATE,
2083: ORGANIZATION_ID,
2084: GROUP_ID,

Line 2106: cln_debug_pub.Add('-------- Values successfully inserted into WSM_SPLIT_MERGE_TXN_INTERFACE --------',1);

2102: p_user_id);
2103:
2104:
2105: IF (g_debug_level <= 1) THEN
2106: cln_debug_pub.Add('-------- Values successfully inserted into WSM_SPLIT_MERGE_TXN_INTERFACE --------',1);
2107: END IF;
2108:
2109:
2110: IF p_process_type = 'WIP_MERGE' THEN

Line 2738: FROM wsm_split_merge_txn_interface

2734: FOR i IN (SELECT message
2735: FROM wsm_interface_errors
2736: WHERE message_type = 1
2737: AND header_id = (SELECT header_id
2738: FROM wsm_split_merge_txn_interface
2739: WHERE group_id = l_group_id))
2740: LOOP
2741: IF (g_debug_level <= 5) THEN
2742: cln_debug_pub.Add('Loop error : ' || i.message, 5);

Line 2811: FROM wsm_split_merge_txn_interface

2807: INTO l_interface_err
2808: FROM WSM_INTERFACE_ERRORS
2809: WHERE MESSAGE_TYPE = 1
2810: AND header_id = ( SELECT HEADER_ID
2811: FROM wsm_split_merge_txn_interface
2812: WHERE group_id = l_group_id);
2813:
2814:
2815: IF (g_debug_level <= 1) THEN