[Home] [Help]
PACKAGE: APPS.AHL_PRD_NONROUTINE_PUB
Source
1 PACKAGE AHL_PRD_NONROUTINE_PUB AS
2 /* $Header: AHLPPNRS.pls 120.0.12010000.1 2008/11/30 21:07:48 sikumar noship $ */
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 );
16 -- Definition of material_requirements_type
17 TYPE MATERIAL_REQUIREMENTS_TBL IS TABLE OF MATERIAL_REQUIREMENT_REC_TYPE INDEX BY BINARY_INTEGER;
18
19 -- Definition of Non Routine Record type
20 TYPE NON_ROUTINE_REC_TYPE IS RECORD
21 (
22 SERVICE_REQUEST_ID NUMBER,
23 OBJECT_VERSION_NUMBER NUMBER,
24 WORKORDER_ID NUMBER,
25 WORKORDER_NUMBER VARCHAR2(80),
26 VISIT_ID NUMBER,
27 VISIT_NUMBER NUMBER,
28 RELEASE_NON_ROUTINE_WORKORDER VARCHAR2(1),
29 ORIGINATOR_WORKORDER_ID NUMBER,
30 ORIGINATOR_WORKORDER_NUMBER VARCHAR2(80),
31 ORIGINATOR_VISIT_ID NUMBER,
32 ORIGINATOR_VISIT_NUMBER NUMBER,
33 ORIGINATOR_TASK NUMBER,
34 SERVICE_REQUEST_TYPE VARCHAR2(30),
35 SERVICE_REQUEST_TYPE_CODE VARCHAR2(30),
36 SUMMARY VARCHAR2(240),
37 PROBLEM_CODE VARCHAR2(50),
38 PROBLEM_CODE_MEANING VARCHAR2(80),
39 RESOLUTION_CODE VARCHAR2(50),
40 RESOLUTION_CODE_MEANING VARCHAR2(240),
41 ESTIMATED_DURATION NUMBER,
42 ESTIMATED_DURATION_UOM VARCHAR2(30),
43 REPORT_BY_TYPE VARCHAR2(80),
44 REPORT_TYPE_CODE VARCHAR2(30),
45 REPORT_TYPE VARCHAR2(80),
46 CONTACT_TYPE_CODE VARCHAR2(50),
47 CONTACT_TYPE VARCHAR2(30),
48 CONTACT_ID NUMBER,
49 CONTACT_NAME VARCHAR2(360),
50 PARTY_ID NUMBER,
51 PARTY_NAME VARCHAR2(360),
52 SERVICE_REQUEST_DATE DATE,
53 SERVICE_REQUEST_STATUS_CODE VARCHAR2(30),
54 SERVICE_REQUEST_STATUS VARCHAR2(80),
55 SEVERITY_ID NUMBER,
56 SEVERITY_NAME VARCHAR2(30),
57 URGENCY_ID NUMBER,
58 URGENCY_NAME VARCHAR2(30),
59 ATA_CODE VARCHAR2(30),
60 POSITION VARCHAR2(30),
61 POSITION_ID NUMBER,
62 UNIT_NAME VARCHAR2(80),
63 ITEM_NUMBER VARCHAR2(40),
64 SERIAL_NUMBER VARCHAR2(30),
65 INSTANCE_NUMBER NUMBER,
66 LOT_NUMBER VARCHAR2(80)
67 );
68
69 -------------------------------------------------------------------------------------------------
70 -- Declare Procedures --
71 -------------------------------------------------------------------------------------------------
72 -- Start of Comments --
73 -- Procedure name : CREATE_NON_ROUTINE
74 -- Type : Public
75 -- Function : Creates a Non routine and adds material requirements for the NR
76 -- Pre-reqs :
77 -- Standard IN Parameters :
78 -- p_api_version IN NUMBER Required
79 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
80 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
81 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
82 -- p_module_type IN VARCHAR2 Default NULL
83 -- Standard OUT Parameters :
84 -- x_return_status OUT VARCHAR2 Required
85 -- x_msg_count OUT NUMBER Required
86 -- x_msg_data OUT VARCHAR2 Required
87 --
88 -- CREATE_NON_ROUTINE Parameters:
89 -- p_create_non_routine_input_rec : Parameters needed for the creation of the NR
90 -- p_matrl_reqrs_for_nr_tbl : Material requirements for the NR
91 -- x_create_non_routine_output_rec : Parameters returned after the creation of the NR
92 -- End of Comments.
93 PROCEDURE CREATE_NON_ROUTINE
94 (
95 p_api_version IN NUMBER := 1.0,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 p_module_type IN VARCHAR2,
100 p_user_id IN VARCHAR2:=NULL,
101 p_create_nr_input_rec IN NON_ROUTINE_REC_TYPE,
102 p_matrl_reqrs_for_nr_tbl IN MATERIAL_REQUIREMENTS_TBL,
103 x_create_nr_output_rec OUT NOCOPY NON_ROUTINE_REC_TYPE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109
110 END AHL_PRD_NONROUTINE_PUB;