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_REPAIR_PO_GRP dependencies on CSP_REPAIR_PO_GRP

Line 1: PACKAGE BODY CSP_REPAIR_PO_GRP AS

1: PACKAGE BODY CSP_REPAIR_PO_GRP AS
2: /* $Header: cspgrpob.pls 120.19.12020000.5 2013/04/12 20:21:58 vidsrini ship $ */
3: -- Purpose: To create Repair execution
4: -- Start of Comments
5: -- Package name : CSP_REPAIR_PO_GRP

Line 5: -- Package name : CSP_REPAIR_PO_GRP

1: PACKAGE BODY CSP_REPAIR_PO_GRP AS
2: /* $Header: cspgrpob.pls 120.19.12020000.5 2013/04/12 20:21:58 vidsrini ship $ */
3: -- Purpose: To create Repair execution
4: -- Start of Comments
5: -- Package name : CSP_REPAIR_PO_GRP
6: -- Purpose : This package creates Repair Purchase Order Requisition and Reservation of defective parts.
7: -- History : 09-June-2005, Arul Joseph.
8: -- NOTE :
9: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_REPAIR_PO_GRP';

7: -- History : 09-June-2005, Arul Joseph.
8: -- NOTE :
9: -- End of Comments
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_REPAIR_PO_GRP';
12: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvprqb.pls';
13:
14: PROCEDURE CREATE_REPAIR_PO
15: (p_api_version IN NUMBER

Line 26: ,P_defective_parts_tbl IN CSP_REPAIR_PO_GRP.defective_parts_tbl_Type

22: ,P_source_organization_id IN NUMBER
23: ,P_repair_to_item_id IN NUMBER
24: ,P_quantity IN NUMBER
25: ,P_need_by_date IN DATE
26: ,P_defective_parts_tbl IN CSP_REPAIR_PO_GRP.defective_parts_tbl_Type
27: ,P_Shipping_method IN varchar2 DEFAULT FND_API.G_MISS_CHAR
28: ,x_requisition_header_id OUT NOCOPY NUMBER
29: ,x_return_status OUT NOCOPY VARCHAR2
30: ,x_msg_count OUT NOCOPY NUMBER

Line 46: l_defective_parts_rec CSP_REPAIR_PO_GRP.defective_parts_rec_type;

42: l_today DATE;
43: EXCP_USER_DEFINED EXCEPTION;
44: l_check_existence NUMBER;
45:
46: l_defective_parts_rec CSP_REPAIR_PO_GRP.defective_parts_rec_type;
47: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;
48:
49: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
50: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;

Line 47: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;

43: EXCP_USER_DEFINED EXCEPTION;
44: l_check_existence NUMBER;
45:
46: l_defective_parts_rec CSP_REPAIR_PO_GRP.defective_parts_rec_type;
47: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;
48:
49: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
50: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;
51: l_out_reservation_tbl CSP_REPAIR_PO_GRP.out_reserve_tbl_type;

Line 50: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;

46: l_defective_parts_rec CSP_REPAIR_PO_GRP.defective_parts_rec_type;
47: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;
48:
49: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
50: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;
51: l_out_reservation_tbl CSP_REPAIR_PO_GRP.out_reserve_tbl_type;
52: x_reservation_id NUMBER;
53:
54: l_header_rec CSP_PARTS_REQUIREMENT.header_rec_type;

Line 51: l_out_reservation_tbl CSP_REPAIR_PO_GRP.out_reserve_tbl_type;

47: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;
48:
49: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
50: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;
51: l_out_reservation_tbl CSP_REPAIR_PO_GRP.out_reserve_tbl_type;
52: x_reservation_id NUMBER;
53:
54: l_header_rec CSP_PARTS_REQUIREMENT.header_rec_type;
55: l_line_rec CSP_PARTS_REQUIREMENT.Line_rec_type;

Line 141: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;
139: End if;
140:
141: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
142: (P_source_organization_id
143: ,l_defective_parts_rec.defective_item_id
144: ,x_item_number
145: ,x_item_description

Line 159: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

155: FND_MSG_PUB.ADD;
156: RAISE EXCP_USER_DEFINED;
157: END IF;
158:
159: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
160: (P_repair_supplier_org_id
161: ,l_defective_parts_rec.defective_item_id
162: ,x_item_number
163: ,x_item_description

Line 345: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

341: FND_MSG_PUB.ADD;
342: RAISE EXCP_USER_DEFINED;
343:
344: Elsif L_REPAIR_ORGANIZATION_NAME is not null then
345: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
346: (P_repair_supplier_org_id
347: ,P_repair_to_item_id
348: ,x_item_number
349: ,x_item_description

Line 389: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

385: FND_MSG_PUB.ADD;
386: RAISE EXCP_USER_DEFINED;
387: Elsif L_DEST_ORGANIZATION_NAME is not null then
388:
389: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
390: (P_dest_organization_id
391: ,P_repair_to_item_id
392: ,x_item_number
393: ,x_item_description

Line 819: l_api_name VARCHAR2(60) := 'CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS';

815: and MSIK.inventory_item_id = P_inventory_item_id
816: and sysdate between nvl(MSIK.start_date_active,sysdate)
817: and nvl(MSIK.end_date_active,sysdate);
818:
819: l_api_name VARCHAR2(60) := 'CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS';
820:
821: BEGIN
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823: OPEN item_cur(P_organization_id,P_inventory_item_id);

Line 953: END CSP_REPAIR_PO_GRP;

949:
950:
951:
952:
953: END CSP_REPAIR_PO_GRP;