APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 701: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;

697: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
698:
699: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
700: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
701: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
702: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
703: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
704: l_transaction_date date;
705: l_quantity NUMBER;

Line 702: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;

698:
699: l_transaction_action_id mtl_transaction_types.transaction_action_id%TYPE;
700: l_transaction_source_type_id mtl_transaction_types.transaction_source_type_id%TYPE;
701: l_transaction_header_id mtl_transactions_interface.transaction_header_id%TYPE;
702: l_transaction_interface_id mtl_transactions_interface.transaction_interface_id%TYPE;
703: l_acct_period_id org_acct_periods.acct_period_id%TYPE;
704: l_transaction_date date;
705: l_quantity NUMBER;
706: l_account_id NUMBER;

Line 1061: FROM MTL_TRANSACTIONS_INTERFACE M

1057: End if;
1058:
1059: Begin
1060: SELECT SHIPMENT_NUMBER INTO l_ship_number
1061: FROM MTL_TRANSACTIONS_INTERFACE M
1062: WHERE M.SHIPMENT_NUMBER = p_shipment_number AND ROWNUM = 1;
1063: Exception
1064: When no_data_found then
1065: l_ship_number := Null;

Line 1090: INSERT INTO mtl_transactions_interface

1086: l_WIP_ENTITY_TYPE := NULL;
1087: l_FINAL_COMPLETION_FLAG := NULL;
1088: End if;
1089:
1090: INSERT INTO mtl_transactions_interface
1091: ( source_code
1092: , source_header_id
1093: , source_line_id
1094: , process_flag

Line 1177: from mtl_transactions_interface

1173: /*
1174: COMMIT;
1175: select process_flag,transaction_source_id,wip_entity_type
1176: into l_process_flag,l_transaction_source_id,l_wip_entity_type
1177: from mtl_transactions_interface
1178: where transaction_header_id = l_transaction_header_id
1179: and transaction_interface_id = l_transaction_interface_id;
1180:
1181: dbms_output.put_line('wip_entity_type '||l_wip_entity_type||' Process_flag '||l_process_flag||' transaction_source_id ' || l_transaction_source_id);

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

1271: /*l_transaction_header_id := 2034265;*/
1272: --dbms_output.put_line('transaction_header_id ' || l_transaction_header_id);
1273:
1274: -- If online_prcoess_flag is true then
1275: -- Call Inventory API for processing transactions in mtl_transactions_interface table
1276: --dbms_output.put_line('transact_material: after calling the apps_initialized');
1277:
1278: IF (p_online_process_flag) THEN
1279:

Line 1316: from mtl_transactions_interface

1312: if(l_retval <> 0) THEN
1313: l_outcome := false;
1314: select error_code, error_explanation
1315: into l_error_code, l_error_explanation
1316: from mtl_transactions_interface
1317: where transaction_header_id = l_transaction_header_id
1318: and rownum = 1;
1319: else
1320: l_outcome := true;

Line 1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;

1349: resp_appl_id => l_prev_resp_appl_id);
1350: END IF;
1351:
1352: IF (l_outcome = FALSE) THEN
1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1354: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1355: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1356: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1357: FND_MSG_PUB.ADD;