APPS.CSP_MO_MTLTXNS_UTIL dependencies on CSP_PACKLIST_HEADERS

Line 382: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

378: l_csp_mtltxn_misc_issue_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
379: l_mtlt_tbl csp_pp_util.g_mtlt_tbl_type;
380: l_msnt_tbl csp_pp_util.g_msnt_tbl_type;
381: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
382: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
383:
384: -- Use 1 as the starting index because it is what the core apps API uses.
385: -- we are not going to update this index becase there is only one record in the
386: -- msnt that is coresponding to the l_packlist_sl_rec.serial_number.

Line 614: FROM csp_packlist_headers

610: SELECT mtl_material_transactions_s.nextval
611: FROM dual;
612: CURSOR l_Get_Packlist_Status_Csr(l_packlist_header_id NUMBER) IS
613: SELECT packlist_status
614: FROM csp_packlist_headers
615: WHERE packlist_header_id = l_packlist_header_id;
616: CURSOR l_Get_Acct_Period_Csr is
617: SELECT acct_period_id
618: FROM org_acct_periods

Line 665: From CSP_PACKLIST_HEADERS

661: ATTRIBUTE12 ,
662: ATTRIBUTE13 ,
663: ATTRIBUTE14 ,
664: ATTRIBUTE15
665: From CSP_PACKLIST_HEADERS
666: WHERE organization_id = p_organization_id
667: AND packlist_header_id = l_packlist_header_id;
668:
669: -- Added to fix bug 1321353.

Line 764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);

760: IF l_packlist_header_status IS NULL THEN
761: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
762: fnd_message.set_token('ERR_FIELD', 'p_packlist_header_status', FALSE);
763: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
764: fnd_message.set_token('TABLE', 'CSP_PACKLIST_HEADERS', FALSE);
765: fnd_msg_pub.add;
766: RAISE EXCP_USER_DEFINED;
767: END IF;
768:

Line 2097: -- Call the CSP_Packlist_Headers_PVT.Update_packlist_headers to update the packlist_status.

2093: l_packlist_headers_rec.date_received := sysdate;
2094: l_packlist_headers_rec.last_update_date := sysdate;
2095: l_packlist_headers_rec.packlist_status := l_packlist_header_status;
2096:
2097: -- Call the CSP_Packlist_Headers_PVT.Update_packlist_headers to update the packlist_status.
2098: CSP_Packlist_Headers_PVT.Update_packlist_headers(
2099: P_Api_Version_Number => l_api_version_number,
2100: P_Init_Msg_List => p_init_msg_list,
2101: P_Commit => FND_API.G_FALSE,

Line 2098: CSP_Packlist_Headers_PVT.Update_packlist_headers(

2094: l_packlist_headers_rec.last_update_date := sysdate;
2095: l_packlist_headers_rec.packlist_status := l_packlist_header_status;
2096:
2097: -- Call the CSP_Packlist_Headers_PVT.Update_packlist_headers to update the packlist_status.
2098: CSP_Packlist_Headers_PVT.Update_packlist_headers(
2099: P_Api_Version_Number => l_api_version_number,
2100: P_Init_Msg_List => p_init_msg_list,
2101: P_Commit => FND_API.G_FALSE,
2102: p_validation_level => l_validation_level,