eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PC_FORM_MTLTXNS dependencies on CSP_MATERIAL_TRANSACTIONS_PVT

Line 233: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

229: l_pick_list_header_id NUMBER;
230: l_commit VARCHAR2(1) := FND_API.G_FALSE;
231: l_creation_date DATE := p_creation_date;
232: l_last_update_date DATE := p_last_update_date;
233: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
234:
235: -- for inserting data, the validation_level should be none
236: -- because we do not want to call core apps standard validations.
237: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

Line 375: -- construct the record to call the procedures in csp_material_transactions_pvt.

371: IF l_last_update_date IS NULL THEN
372: l_last_update_date := sysdate;
373: END IF;
374:
375: -- construct the record to call the procedures in csp_material_transactions_pvt.
376: l_csp_mtltxn_rec.TRANSACTION_HEADER_ID := p_TRANSACTION_HEADER_ID;
377: l_csp_mtltxn_rec.TRANSACTION_TEMP_ID := px_TRANSACTION_TEMP_ID;
378: l_csp_mtltxn_rec.SOURCE_CODE := p_SOURCE_CODE;
379: l_csp_mtltxn_rec.SOURCE_LINE_ID := p_SOURCE_LINE_ID;

Line 570: CSP_Material_Transactions_PVT.Create_material_transactions(

566: --l_csp_mtltxn_rec.SOURCE_LOT_NUMBER := p_SOURCE_LOT_NUMBER;
567:
568: IF p_action_code = 0 THEN
569: -- call the create_material
570: CSP_Material_Transactions_PVT.Create_material_transactions(
571: P_Api_Version_Number => p_api_version_number,
572: P_Init_Msg_List => p_init_msg_list,
573: P_Commit => l_commit,
574: p_validation_level => p_validation_level,

Line 583: CSP_Material_Transactions_PVT.Update_material_transactions(

579: X_Msg_Data => l_msg_data
580: );
581: ELSIF p_action_code = 1 THEN
582: -- call the update_material
583: CSP_Material_Transactions_PVT.Update_material_transactions(
584: P_Api_Version_Number => p_api_version_number,
585: P_Init_Msg_List => p_init_msg_list,
586: P_Commit => l_commit,
587: p_validation_level => p_validation_level,

Line 595: CSP_Material_Transactions_PVT.Delete_material_transactions(

591: X_Msg_Data => l_msg_data
592: );
593: ELSE
594: -- call the delete_material
595: CSP_Material_Transactions_PVT.Delete_material_transactions(
596: P_Api_Version_Number => p_api_version_number,
597: P_Init_Msg_List => p_init_msg_list,
598: P_Commit => l_commit,
599: p_validation_level => p_validation_level,

Line 697: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

693: l_msg_count NUMBER := 0;
694: l_commit VARCHAR2(1) := FND_API.G_FALSE;
695: l_creation_date DATE;
696: l_last_update_date DATE;
697: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
699:
700: -- for inserting data, the validation_level should be none
701: -- because we do not want to call core apps standard validations.

Line 698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

694: l_commit VARCHAR2(1) := FND_API.G_FALSE;
695: l_creation_date DATE;
696: l_last_update_date DATE;
697: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
699:
700: -- for inserting data, the validation_level should be none
701: -- because we do not want to call core apps standard validations.
702: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

Line 1016: -- 7. Call the CSP_Material_Transactions_PVT.Update_material_transactions to update

1012: -- 5. Update the transaction_source_type_id to 13 (inventory),
1013: -- transaction_type_id to 2 (subinventory transfer) and
1014: -- transaction_action_id to 2 (subinventory transfer).
1015: -- 6. Update the process_flag to 'Y'.
1016: -- 7. Call the CSP_Material_Transactions_PVT.Update_material_transactions to update
1017: -- the transfer_subinventory to the instransit subinventory.
1018: -- 8. Call the csp_transactions_pub.transact_temp_record to insert the temp data into the interface table.
1019: -- 9. Check the return status. If successful, proceed to stage 2. otherwise, close cursor. Raise an exception.
1020: -----------------------------------------------------------------------------------------------

Line 1143: -- CSP_Material_Transactions_PVT.Create_material_transactions will create a new

1139: END IF;
1140: END;
1141:
1142: -- Assign the transaction_temp_id of the p_csp_rec to NULL so that the
1143: -- CSP_Material_Transactions_PVT.Create_material_transactions will create a new
1144: -- transaction_temp_id from the sequence.
1145:
1146: -- l_csp_mtltxn_new_rec.transaction_temp_id := NULL;
1147:

Line 1148: CSP_Material_Transactions_PVT.Update_material_transactions(

1144: -- transaction_temp_id from the sequence.
1145:
1146: -- l_csp_mtltxn_new_rec.transaction_temp_id := NULL;
1147:
1148: CSP_Material_Transactions_PVT.Update_material_transactions(
1149: P_Api_Version_Number => p_api_version_number,
1150: P_Init_Msg_List => p_init_msg_list,
1151: P_Commit => l_commit,
1152: p_validation_level => l_validation_level,

Line 1206: -- 6. Call the CSP_Material_Transactions_PVT.update_material_transactions.

1202: -- 2. Update the locator_id to NULL.
1203: -- 3. Update the transfer_subinventory to l_to_subinventory.
1204: -- 4. Update the tansfer_to_location to l_to_locator.
1205: -- 5. Update the process_flag to 'N'.
1206: -- 6. Call the CSP_Material_Transactions_PVT.update_material_transactions.
1207:
1208: l_csp_mtltxn_rec.subinventory_code := l_csp_intransit_subinventory;
1209: l_csp_mtltxn_rec.locator_id := NULL;
1210: l_csp_mtltxn_rec.transfer_subinventory := l_to_subinventory;

Line 1216: CSP_Material_Transactions_PVT.Update_material_transactions(

1212: l_csp_mtltxn_rec.process_flag := 'N';
1213: l_csp_mtltxn_rec.LAST_UPDATE_DATE := sysdate;
1214: -- l_csp_mtltxn_rec.CREATION_DATE := sysdate;
1215:
1216: CSP_Material_Transactions_PVT.Update_material_transactions(
1217: P_Api_Version_Number => p_api_version_number,
1218: P_Init_Msg_List => p_init_msg_list,
1219: P_Commit => fnd_api.g_false,
1220: p_validation_level => l_validation_level,

Line 1336: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;

1332: l_msg_count NUMBER := 0;
1333: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1334: l_creation_date DATE;
1335: l_last_update_date DATE;
1336: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
1337:
1338: -- for inserting data, the validation_level should be none
1339: -- because we do not want to call core apps standard validations.
1340: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

Line 1651: -- 4. Calll CSP_Material_Transactions_PVT.Update_material_transactions to update the

1647: ---------------------------------------------------------------------------------------------
1648: -- 1. Open the cursor c_mtl_records.
1649: -- 2. Fecth one row into l_csp_mtltxn_rec.
1650: -- 3. Set process_flag to 'Y' and transaction_status to 3.
1651: -- 4. Calll CSP_Material_Transactions_PVT.Update_material_transactions to update the
1652:
1653: OPEN c_ml_records;
1654: LOOP
1655: FETCH c_ml_records into l_csp_mtltxn_rec;

Line 1666: CSP_Material_Transactions_PVT.Update_material_transactions(

1662: l_csp_mtltxn_rec.LAST_UPDATE_DATE := sysdate;
1663: l_csp_mtltxn_rec.CREATION_DATE := sysdate;
1664:
1665:
1666: CSP_Material_Transactions_PVT.Update_material_transactions(
1667: P_Api_Version_Number => p_api_version_number,
1668: P_Init_Msg_List => p_init_msg_list,
1669: P_Commit => fnd_api.g_false,
1670: p_validation_level => l_validation_level,