APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 646: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;

642: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
643:
644: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
645: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
646: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
647: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
648: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
649: l_quantity NUMBER;
650: l_account_id NUMBER;

Line 647: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;

643:
644: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
645: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
646: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
647: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
648: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
649: l_quantity NUMBER;
650: l_account_id NUMBER;
651: l_code_comb_id NUMBER;

Line 936: FROM MTL_TRANSACTIONS_INTERFACE M

932: End if;
933:
934: Begin
935: SELECT SHIPMENT_NUMBER INTO l_ship_number
936: FROM MTL_TRANSACTIONS_INTERFACE M
937: WHERE M.SHIPMENT_NUMBER = p_shipment_number AND ROWNUM = 1;
938: Exception
939: When no_data_found then
940: l_ship_number := Null;

Line 965: INSERT INTO mtl_transactions_interface

961: l_WIP_ENTITY_TYPE := NULL;
962: l_FINAL_COMPLETION_FLAG := NULL;
963: End if;
964:
965: INSERT INTO mtl_transactions_interface
966: ( source_code
967: , source_header_id
968: , source_line_id
969: , process_flag

Line 1052: from mtl_transactions_interface

1048: /*
1049: COMMIT;
1050: select process_flag,transaction_source_id,wip_entity_type
1051: into l_process_flag,l_transaction_source_id,l_wip_entity_type
1052: from mtl_transactions_interface
1053: where transaction_header_id = l_transaction_header_id
1054: and transaction_interface_id = l_transaction_interface_id;
1055:
1056: dbms_output.put_line('wip_entity_type '||l_wip_entity_type||' Process_flag '||l_process_flag||' transaction_source_id ' || l_transaction_source_id);

Line 1150: -- Call Inventory API for processing transactions in mtl_transactions_interface table

1146: /*l_transaction_header_id := 2034265;*/
1147: --dbms_output.put_line('transaction_header_id ' || l_transaction_header_id);
1148:
1149: -- If online_prcoess_flag is true then
1150: -- Call Inventory API for processing transactions in mtl_transactions_interface table
1151: --dbms_output.put_line('transact_material: after calling the apps_initialized');
1152:
1153: IF (p_online_process_flag) THEN
1154:

Line 1191: from mtl_transactions_interface

1187: if(l_retval <> 0) THEN
1188: l_outcome := false;
1189: select error_code, error_explanation
1190: into l_error_code, l_error_explanation
1191: from mtl_transactions_interface
1192: where transaction_header_id = l_transaction_header_id
1193: and rownum = 1;
1194: else
1195: l_outcome := true;

Line 1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;

1224: resp_appl_id => l_prev_resp_appl_id);
1225: END IF;
1226:
1227: IF (l_outcome = FALSE) THEN
1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1232: FND_MSG_PUB.ADD;