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 2007/09/19 18:39:26 ajosephg 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 2007/09/19 18:39:26 ajosephg 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: ,x_requisition_header_id OUT NOCOPY NUMBER
28: ,x_return_status OUT NOCOPY VARCHAR2
29: ,x_msg_count OUT NOCOPY NUMBER
30: ,x_msg_data OUT NOCOPY VARCHAR2

Line 45: l_defective_parts_rec CSP_REPAIR_PO_GRP.defective_parts_rec_type;

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

Line 46: l_defective_parts_tbl CSP_REPAIR_PO_GRP.defective_parts_tbl_Type;

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

Line 49: l_out_reservation_rec CSP_REPAIR_PO_GRP.out_reserve_rec_type;

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

Line 50: l_out_reservation_tbl CSP_REPAIR_PO_GRP.out_reserve_tbl_type;

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

Line 138: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

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

Line 156: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

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

Line 340: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

336: FND_MSG_PUB.ADD;
337: RAISE EXCP_USER_DEFINED;
338:
339: Elsif L_REPAIR_ORGANIZATION_NAME is not null then
340: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
341: (P_repair_supplier_org_id
342: ,P_repair_to_item_id
343: ,x_item_number
344: ,x_item_description

Line 384: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

380: FND_MSG_PUB.ADD;
381: RAISE EXCP_USER_DEFINED;
382: Elsif L_DEST_ORGANIZATION_NAME is not null then
383:
384: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS
385: (P_dest_organization_id
386: ,P_repair_to_item_id
387: ,x_item_number
388: ,x_item_description

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

808: and MSIK.inventory_item_id = P_inventory_item_id
809: and sysdate between nvl(MSIK.start_date_active,sysdate)
810: and nvl(MSIK.end_date_active,sysdate);
811:
812: l_api_name VARCHAR2(60) := 'CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS';
813:
814: BEGIN
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
816: OPEN item_cur(P_organization_id,P_inventory_item_id);

Line 944: END CSP_REPAIR_PO_GRP;

940:
941:
942:
943:
944: END CSP_REPAIR_PO_GRP;