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 171: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE

167: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_ITEMCOST_PVT.UPDATE_ITEMCOST';
168:
169: TYPE inventory_item_id_tbl IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE
170: INDEX BY PLS_INTEGER;
171: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE
172: INDEX BY PLS_INTEGER;
173: TYPE source_line_id_tbl IS TABLE OF mtl_transactions_interface.source_line_id%TYPE
174: INDEX BY PLS_INTEGER;
175: TYPE transaction_id_tbl IS TABLE OF mtl_material_transactions.transaction_id%TYPE

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

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

Line 951: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,

947: 1);
948:
949: l_status_Update_tbl(i).update_status := 'Y';
950: ELSIF Item_rec.primary_cost_method = 2 THEN
951: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,
952: Transaction_Header_Id,
953: Source_Code,
954: Source_Line_Id,
955: Source_Header_Id,

Line 1077: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,

1073: 1);
1074:
1075: l_status_Update_tbl(i).update_status := 'Y';
1076: ELSIF Item_rec.primary_cost_method = 2 THEN
1077: INSERT INTO mtl_Transactions_InterFace(Transaction_InterFace_Id,
1078: Transaction_Header_Id,
1079: Source_Code,
1080: Source_Line_Id,
1081: Source_Header_Id,

Line 1305: FROM mtl_Transactions_InterFace

1301:
1302: -- Begin Error Processing for Avg Cost Update
1303: SELECT COUNT(* )
1304: INTO l_InterFace_Pending_Count
1305: FROM mtl_Transactions_InterFace
1306: WHERE Source_Code = 'Price Protection'
1307: AND Source_Header_Id = l_txn_hdr_rec.Execution_Detail_Id
1308: AND Transaction_Header_Id = l_txn_hdr_rec.Transaction_Header_Id
1309: AND Process_Flag = 1;

Line 1326: FROM mtl_Transactions_InterFace

1322: SELECT Source_Line_Id,
1323: Nvl(Error_Explanation,Error_Code) Error_Explanation
1324: BULK COLLECT INTO Source_Line_Ids,
1325: Error_Explanations
1326: FROM mtl_Transactions_InterFace
1327: WHERE Source_Code = 'Price Protection'
1328: AND Source_Header_Id = l_txn_hdr_rec.Execution_Detail_Id
1329: AND Transaction_Header_Id = l_txn_hdr_rec.Transaction_Header_Id
1330: AND Process_Flag = 3;