APPS.DPP_ITEMCOST_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 54: mtl_transactions_interface

50: count(*)
51: INTO
52: l_interface_pending_count
53: FROM
54: mtl_transactions_interface
55: WHERE
56: source_code = 'Price Protection' AND
57: source_header_id = in_execution_detail_id AND
58: transaction_header_id = in_transaction_header_id AND

Line 170: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE

166: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
167:
168: TYPE inventory_item_id_tbl IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE
169: INDEX BY PLS_INTEGER;
170: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE
171: INDEX BY PLS_INTEGER;
172: TYPE source_line_id_tbl IS TABLE OF mtl_transactions_interface.source_line_id%TYPE
173: INDEX BY PLS_INTEGER;
174: TYPE transaction_id_tbl IS TABLE OF mtl_material_transactions.transaction_id%TYPE

Line 172: TYPE source_line_id_tbl IS TABLE OF mtl_transactions_interface.source_line_id%TYPE

168: TYPE inventory_item_id_tbl IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE
169: INDEX BY PLS_INTEGER;
170: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE
171: INDEX BY PLS_INTEGER;
172: TYPE source_line_id_tbl IS TABLE OF mtl_transactions_interface.source_line_id%TYPE
173: INDEX BY PLS_INTEGER;
174: TYPE transaction_id_tbl IS TABLE OF mtl_material_transactions.transaction_id%TYPE
175: INDEX BY PLS_INTEGER;
176: TYPE transaction_line_id_tbl IS TABLE OF dpp_transaction_lines_all.transaction_line_id%TYPE

Line 957: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,

953: 1);
954:
955: l_status_Update_tbl(i).update_status := 'Y';
956: ELSIF Item_rec.primary_cost_method = 2 THEN
957: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,
958: Transaction_Header_Id,
959: Source_Code,
960: Source_Line_Id,
961: Source_Header_Id,

Line 1085: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,

1081: 1);
1082:
1083: l_status_Update_tbl(i).update_status := 'Y';
1084: ELSIF Item_rec.primary_cost_method = 2 THEN
1085: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,
1086: Transaction_Header_Id,
1087: Source_Code,
1088: Source_Line_Id,
1089: Source_Header_Id,

Line 1330: FROM mtl_Transactions_InterFace

1326:
1327: -- Begin Error Processing for Avg Cost Update
1328: SELECT COUNT(* )
1329: INTO l_InterFace_Pending_Count
1330: FROM mtl_Transactions_InterFace
1331: WHERE Source_Code = 'Price Protection'
1332: AND Source_Header_Id = l_txn_hdr_rec.Execution_Detail_Id
1333: AND Transaction_Header_Id = l_txn_hdr_rec.Transaction_Header_Id
1334: AND Process_Flag = 1;

Line 1353: FROM mtl_Transactions_InterFace

1349: SELECT Source_Line_Id,
1350: Nvl(Error_Explanation,Error_Code) Error_Explanation
1351: BULK COLLECT INTO Source_Line_Ids,
1352: Error_Explanations
1353: FROM mtl_Transactions_InterFace
1354: WHERE Source_Code = 'Price Protection'
1355: AND Source_Header_Id = l_txn_hdr_rec.Execution_Detail_Id
1356: AND Transaction_Header_Id = l_txn_hdr_rec.Transaction_Header_Id
1357: AND Process_Flag = 3;