DBA Data[Home] [Help]

APPS.CSP_PL_SHIP_UTIL dependencies on CSP_PACKLIST_HEADERS_PVT

Line 169: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

165: From CSP_PACKLIST_HEADERS
166: WHERE organization_id = p_organization_id
167: AND packlist_header_id = p_packlist_header_id;
168:
169: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
170: l_packlist_line_rec CSP_packlist_lines_PVT.PLL_Rec_Type;
171: l_transaction_header_id NUMBER := null;
172: l_temp_id NUMBER;
173: l_move_order_line_id NUMBER;

Line 296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.

292: x_return_status => l_return_status,
293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data );*/
295:
296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
297: CSP_Packlist_Headers_PVT.Update_packlist_headers(
298: P_Api_Version_Number => l_api_version_number,
299: P_Init_Msg_List => p_init_msg_list,
300: P_Commit => FND_API.G_FALSE,

Line 297: CSP_Packlist_Headers_PVT.Update_packlist_headers(

293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data );*/
295:
296: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
297: CSP_Packlist_Headers_PVT.Update_packlist_headers(
298: P_Api_Version_Number => l_api_version_number,
299: P_Init_Msg_List => p_init_msg_list,
300: P_Commit => FND_API.G_FALSE,
301: p_validation_level => l_validation_level,

Line 901: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;

897: From CSP_PACKLIST_HEADERS
898: WHERE organization_id = p_organization_id
899: AND packlist_header_id = p_packlist_header_id;
900:
901: l_packlist_headers_rec CSP_packlist_headers_PVT.PLH_Rec_Type;
902: l_api_version_number CONSTANT NUMBER := 1.0;
903: l_api_name CONSTANT VARCHAR2(50) := 'Update_Packlist_Sts_Qty';
904: l_msg_count NUMBER;
905: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.

1005: END IF;
1006:
1007: l_packlist_headers_rec.last_update_date := sysdate;
1008:
1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(
1011: P_Api_Version_Number => l_api_version_number,
1012: P_Init_Msg_List => p_init_msg_list,
1013: P_Commit => FND_API.G_FALSE,

Line 1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(

1006:
1007: l_packlist_headers_rec.last_update_date := sysdate;
1008:
1009: -- call the CSP_Packlist_Headers_PVT.Update_packlist_headers to updat the packlist_status.
1010: CSP_Packlist_Headers_PVT.Update_packlist_headers(
1011: P_Api_Version_Number => l_api_version_number,
1012: P_Init_Msg_List => p_init_msg_list,
1013: P_Commit => FND_API.G_FALSE,
1014: p_validation_level => l_validation_level,