APPS.CSP_PL_SHIP_UTIL dependencies on CSP_PACKLIST_LINES

Line 27: -- Purpose : This procedure updates the packlist_line_status and the quantity_shipped in the csp_packlist_lines table.

23: PROCEDURE Confirm_Ship(
24: /* $Header: cspgtpsb.pls 120.0 2005/05/25 11:27:47 appldev noship $ */
25: -- Start of Comments
26: -- Procedure name : Confirm_Ship
27: -- Purpose : This procedure updates the packlist_line_status and the quantity_shipped in the csp_packlist_lines table.
28: -- It requires the packlist_header_id and the quantity_shipped.
29: -- History :
30: -- Userid Date Comments
31: -- --------- ------ ------------------------------------------

Line 123: From CSP_PACKLIST_LINES

119: ATTRIBUTE14,
120: ATTRIBUTE15,
121: UOM_CODE,
122: LINE_ID
123: From CSP_PACKLIST_LINES
124: WHERE organization_id = p_organization_id
125: AND packlist_header_id = p_packlist_header_id;
126:
127: Cursor C_Get_Packlist_Headers IS

Line 170: l_packlist_line_rec CSP_packlist_lines_PVT.PLL_Rec_Type;

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;
174: l_header_id NUMBER;

Line 564: l_packlist_line_rec CSP_packlist_lines_PVT.PLL_Rec_Type;

560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2)
563: IS
564: l_packlist_line_rec CSP_packlist_lines_PVT.PLL_Rec_Type;
565:
566: Cursor C_Get_packlist_lines IS
567: Select PACKLIST_LINE_ID,
568: CREATED_BY,

Line 601: From CSP_PACKLIST_LINES

597: ATTRIBUTE14,
598: ATTRIBUTE15,
599: UOM_CODE,
600: LINE_ID
601: From CSP_PACKLIST_LINES
602: WHERE organization_id = p_organization_id
603: AND packlist_line_id = p_packlist_line_id;
604: -- For Update NOWAIT;
605:

Line 670: from csp_packlist_lines

666: ELSE
667: IF p_validation_level = fnd_api.g_valid_level_full THEN
668: BEGIN
669: select packlist_line_id into l_check_existence
670: from csp_packlist_lines
671: where organization_id = p_organization_id
672: and packlist_line_id = p_packlist_line_id;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN

Line 682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);

678: WHEN OTHERS THEN
679: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
680: fnd_message.set_token('ERR_FIELD', 'p_packlist_line_id', TRUE);
681: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
682: fnd_message.set_token('TABLE', 'csp_packlist_lines', TRUE);
683: fnd_msg_pub.add;
684: RAISE EXCP_USER_DEFINED;
685:
686: END;

Line 716: CSP_packlist_lines_PVT.Update_packlist_lines(

712: l_packlist_line_rec.quantity_received:= p_quantity_received;
713: END IF;
714:
715: l_packlist_line_rec.last_update_date := sysdate;
716: CSP_packlist_lines_PVT.Update_packlist_lines(
717: P_Api_Version_Number => l_api_version_number,
718: P_Init_Msg_List => FND_API.G_FALSE,
719: P_Commit => FND_API.G_FALSE,
720: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 797: FROM CSP_Packlist_LINES

793: l_line_id NUMBER;
794: l_line_status VARCHAR2(30) := '-1';
795: CURSOR C_Get_Packlist_Lines IS
796: SELECT packlist_line_id
797: FROM CSP_Packlist_LINES
798: WHERE packlist_header_id = p_packlist_header_id;
799:
800: BEGIN
801: OPEN C_Get_Packlist_Lines;

Line 808: FROM CSP_Packlist_Lines

804: EXIT WHEN C_Get_Packlist_Lines%NOTFOUND;
805:
806: BEGIN
807: SELECT packlist_line_status INTO l_line_status
808: FROM CSP_Packlist_Lines
809: WHERE packlist_line_id = l_line_id;
810:
811: IF l_line_status <> p_status_to_be_validated THEN
812: IF p_check_receipt_short THEN