APPS.CSP_PC_FORM_MTLTXNS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 6: -- records in the mtl_material_transactions_temp table.

2: /*$Header: cspgtmxb.pls 120.0 2005/05/24 18:13:03 appldev noship $*/
3: -- Start of Comments
4: -- Package name : CSP_PC_FORM_MTLTXNS
5: -- Purpose : CSP procedures for csp move order transactions.CSP procedures to insert, update and delete
6: -- records in the mtl_material_transactions_temp table.
7: -- History :
8: -- 27-Dec-99, Add procedure CSP_MO_Lines_Manual_Receipt.
9: -- 20-Dec-99, klou.
10: --

Line 295: FROM mtl_material_transactions_temp

291:
292: -- check whehter the px_transaction_temp_id already exists. If yes, raise an exception.
293: BEGIN
294: SELECT transaction_temp_id into l_check_existence
295: FROM mtl_material_transactions_temp
296: WHERE transaction_temp_id = px_transaction_temp_id
297: AND organization_id = p_organization_id;
298:
299: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');

Line 316: from mtl_material_transactions_temp

312: RAISE EXCP_USER_DEFINED;
313: ELSE
314: BEGIN
315: select transaction_temp_id into l_check_existence
316: from mtl_material_transactions_temp
317: where organization_id = p_organization_id
318: and transaction_temp_id = px_transaction_temp_id;
319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN

Line 331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);

327: WHEN OTHERS THEN
328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
333: RAISE EXCP_USER_DEFINED;
334: END;
335: END IF;

Line 712: -- declare a cursor to hold all the records in the mtl_material_transactions_temp table

708: l_transaction_temp_id NUMBER := NULL;
709: l_transaction_header_id NUMBER := px_transaction_header_id;
710: EXCP_USER_DEFINED EXCEPTION;
711:
712: -- declare a cursor to hold all the records in the mtl_material_transactions_temp table
713: -- that belong to the move_order_line_id.
714: CURSOR c_ml_records IS
715: SELECT TRANSACTION_HEADER_ID ,
716: TRANSACTION_TEMP_ID ,

Line 907: FROM mtl_material_transactions_temp

903: -- ADDED by phegde 02/23
904: WMS_TASK_TYPE ,
905: PARENT_LINE_ID
906: -- SOURCE_LOT_NUMBER
907: FROM mtl_material_transactions_temp
908: WHERE transaction_temp_id = p_transaction_temp_id
909: AND organization_id = p_organization_id;
910:
911: Cursor l_Get_txn_header_id_csr IS

Line 1236: -- If it gets to here, processing the mtl_material_transactions_temp should complete successfully.

1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: -- If it gets to here, processing the mtl_material_transactions_temp should complete successfully.
1237: IF c_ml_records%ISOPEN THEN
1238: close c_ml_records;
1239: END IF;
1240:

Line 1345: -- declare a cursor to hold all the records in the mtl_material_transactions_temp table

1341: l_transaction_temp_id NUMBER;
1342:
1343: EXCP_USER_DEFINED EXCEPTION;
1344:
1345: -- declare a cursor to hold all the records in the mtl_material_transactions_temp table
1346: -- that belong to the move_order_line_id.
1347: CURSOR c_ml_records IS
1348: SELECT TRANSACTION_HEADER_ID ,
1349: TRANSACTION_TEMP_ID ,

Line 1540: FROM mtl_material_transactions_temp

1536: -- ADDED by phegde 02/23
1537: WMS_TASK_TYPE ,
1538: PARENT_LINE_ID
1539: --SOURCE_LOT_NUMBER
1540: FROM mtl_material_transactions_temp
1541: WHERE transaction_temp_id = p_transaction_temp_id
1542: AND organization_id = p_organization_id;
1543: BEGIN
1544: SAVEPOINT CSP_MO_Lines_Auto_PUB;

Line 1608: from mtl_material_transactions_temp

1604:
1605: -- validate whether the move_order_line_id exists
1606: BEGIN
1607: select move_order_line_id into l_move_order_line_id
1608: from mtl_material_transactions_temp
1609: where transaction_temp_id = p_transaction_temp_id
1610: and organization_id = p_organization_id;
1611:
1612: