[Home] [Help]
PACKAGE: APPS.AHL_PRD_NONROUTINE_PUB
Source
1 PACKAGE AHL_PRD_NONROUTINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPPNRS.pls 120.2.12020000.2 2012/12/10 15:45:58 prakkum ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_CREATE_NON_ROUTINE_SERVICE';
5
6 -- Definition of material_requirement_rec_type
7 TYPE MATERIAL_REQUIREMENT_REC_TYPE IS RECORD
8 (
9 INVENTORY_ITEM_ID NUMBER,
10 ITEM_NUMBER VARCHAR2(40),
11 ITEM_DESCRIPTION VARCHAR2(240),
12 REQUIRED_QUANTITY NUMBER,
13 PART_UOM VARCHAR2(30),
14 REQUIRED_DATE DATE,
15 --sukhwsin: SB Effectivity - Added new attributes for position based requirements - starts
16 MC_HEADER_ID NUMBER,
17 MC_NAME VARCHAR2(80),
18 MC_POSITION_KEY NUMBER,
19 MC_POSITION VARCHAR2(80),
20 ITEM_GROUP_ID NUMBER,
21 ITEM_GROUP_NAME VARCHAR2(80)
22 --sukhwsin: SB Effectivity - Added new attributes for position based requirements - ends
23 );
24 -- Definition of material_requirements_type
25 TYPE MATERIAL_REQUIREMENTS_TBL IS TABLE OF MATERIAL_REQUIREMENT_REC_TYPE INDEX BY BINARY_INTEGER;
26
27 -- Definition of Non Routine Record type
28 TYPE NON_ROUTINE_REC_TYPE IS RECORD
29 (
30 SERVICE_REQUEST_ID NUMBER,
31 OBJECT_VERSION_NUMBER NUMBER,
32 WORKORDER_ID NUMBER,
33 WORKORDER_NUMBER VARCHAR2(80),
34 VISIT_ID NUMBER,
35 VISIT_NUMBER NUMBER,
36 RELEASE_NON_ROUTINE_WORKORDER VARCHAR2(1),
37 ORIGINATOR_WORKORDER_ID NUMBER,
38 ORIGINATOR_WORKORDER_NUMBER VARCHAR2(80),
39 ORIGINATOR_VISIT_ID NUMBER,
40 ORIGINATOR_VISIT_NUMBER NUMBER,
41 ORIGINATOR_TASK NUMBER,
42 SERVICE_REQUEST_TYPE VARCHAR2(30),
43 SERVICE_REQUEST_TYPE_CODE VARCHAR2(30),
44 SUMMARY VARCHAR2(240),
45 PROBLEM_CODE VARCHAR2(50),
46 PROBLEM_CODE_MEANING VARCHAR2(80),
47 RESOLUTION_CODE VARCHAR2(50),
48 RESOLUTION_CODE_MEANING VARCHAR2(240),
49 ESTIMATED_DURATION NUMBER,
50 ESTIMATED_DURATION_UOM VARCHAR2(30),
51 REPORT_BY_TYPE VARCHAR2(80),
52 REPORT_TYPE_CODE VARCHAR2(30),
53 REPORT_TYPE VARCHAR2(80),
54 CONTACT_TYPE_CODE VARCHAR2(50),
55 CONTACT_TYPE VARCHAR2(30),
56 CONTACT_ID NUMBER,
57 CONTACT_NAME VARCHAR2(360),
58 PARTY_ID NUMBER,
59 PARTY_NAME VARCHAR2(360),
60 SERVICE_REQUEST_DATE DATE,
61 SERVICE_REQUEST_STATUS_CODE VARCHAR2(30),
62 SERVICE_REQUEST_STATUS VARCHAR2(80),
63 SEVERITY_ID NUMBER,
64 SEVERITY_NAME VARCHAR2(30),
65 URGENCY_ID NUMBER,
66 URGENCY_NAME VARCHAR2(30),
67 ATA_CODE VARCHAR2(30),
68 POSITION VARCHAR2(30),
69 POSITION_ID NUMBER,
70 UNIT_NAME VARCHAR2(80),
71 ITEM_NUMBER VARCHAR2(40),
72 SERIAL_NUMBER VARCHAR2(30),
73 INSTANCE_NUMBER NUMBER,
74 LOT_NUMBER VARCHAR2(80)
75 );
76
77 -------------------------------------------------------------------------------------------------
78 -- Declare Procedures --
79 -------------------------------------------------------------------------------------------------
80 -- Start of Comments --
81 -- Procedure name : CREATE_NON_ROUTINE
82 -- Type : Public
83 -- Function : Creates a Non routine and adds material requirements for the NR
84 -- Pre-reqs :
85 -- Standard IN Parameters :
86 -- p_api_version IN NUMBER Required
87 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
88 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
89 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
90 -- p_module_type IN VARCHAR2 Default NULL
91 -- Standard OUT Parameters :
92 -- x_return_status OUT VARCHAR2 Required
93 -- x_msg_count OUT NUMBER Required
94 -- x_msg_data OUT VARCHAR2 Required
95 --
96 -- CREATE_NON_ROUTINE Parameters:
97 -- p_create_non_routine_input_rec : Parameters needed for the creation of the NR
98 -- p_matrl_reqrs_for_nr_tbl : Material requirements for the NR
99 -- x_create_non_routine_output_rec : Parameters returned after the creation of the NR
100 -- End of Comments.
101 PROCEDURE CREATE_NON_ROUTINE
102 (
103 p_api_version IN NUMBER := 1.0,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 p_module_type IN VARCHAR2,
108 p_user_id IN VARCHAR2:=NULL,
109 p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,
110 p_matrl_reqrs_for_nr_tbl IN MATERIAL_REQUIREMENTS_TBL,
111 x_create_nr_output_rec OUT NOCOPY NON_ROUTINE_REC_TYPE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2
115 );
116
117
118 END AHL_PRD_NONROUTINE_PUB;