1 PACKAGE AHL_PRD_NONROUTINE_PVT AS
2 /* $Header: AHLVPNRS.pls 120.3 2008/01/31 15:13:17 amsriniv ship $ */
3 -----------------------------------------------------------
4 -- Record Types for record structures needed by the APIs --
5 -----------------------------------------------------------
6 -- Record for service record and vwp task
7
8 TYPE sr_task_rec_type IS RECORD (
9 Request_date DATE ,
10 Type_id NUMBER ,
11 Type_name VARCHAR2(30) ,
12 Status_id NUMBER ,
13 Status_name VARCHAR2(30) ,
14 Severity_id NUMBER ,
15 Severity_name VARCHAR2(30) ,
16 Urgency_id NUMBER ,
17 Urgency_name VARCHAR2(30) ,
18 Summary VARCHAR2(240) ,
19 Customer_type VARCHAR2(30) ,
20 Customer_id NUMBER ,
21 Customer_number VARCHAR2(30) ,
22 Customer_name VARCHAR2(360) ,
23 Contact_type VARCHAR2(30) ,
24 Contact_id NUMBER ,
25 Contact_number VARCHAR2(30) ,
26 Contact_name VARCHAR2(360) ,
27 Instance_id NUMBER ,
28 Instance_number VARCHAR2(30) ,
29 Problem_code VARCHAR2(50) ,
30 Problem_meaning VARCHAR2(80) ,
31 Resolution_code VARCHAR2(50) ,
32 Resolution_meaning VARCHAR2(240) ,
33 Incident_id NUMBER ,
34 Incident_number VARCHAR2(30) ,
35 Incident_object_version_number NUMBER ,
36 Visit_id NUMBER ,
37 Visit_number NUMBER ,
38 Duration NUMBER ,
39 Task_type_code VARCHAR2(30) ,
40 Visit_task_id NUMBER ,
41 Visit_task_number NUMBER ,
42 Visit_task_name VARCHAR2(80) ,
43 Operation_type VARCHAR2(15) ,
44 Workflow_process_id NUMBER ,
45 Interaction_id NUMBER ,
46 Originating_wo_id NUMBER ,
47 Nonroutine_wo_id NUMBER ,
48 source_program_code VARCHAR2(30) ,
49 --Modified by VSUNDARA For TRANSIT CHECK ENHANCEMENT
50 Object_id NUMBER ,
51 Object_type VARCHAR2(80) ,
52 link_id NUMBER ,
53 -- Modified for bug# 5261150 in R12.
54 -- FP for ER 5716489 -- start
55 WO_Create_flag VARCHAR2(1),
56 WO_Release_flag VARCHAR2(1),
57 -- FP for ER 5716489 -- end
58 instance_quantity NUMBER, --amsriniv . ER 6014567
59 move_qty_to_nr_workorder VARCHAR2(1) --amsriniv . ER 6014567
60 );
61
62 G_MISS_Sr_Task_Rec Sr_task_rec_type;
63 ----------------------------------------------
64 -- Define Table Type for Records Structures --
65 ----------------------------------------------
66 --Declare Sr_Task table type for Sr_task_rec record
67
68 TYPE Sr_task_tbl_type IS TABLE OF Sr_task_rec_type INDEX BY BINARY_INTEGER;
69
70 -- MR NR ER -- Start
71 ---------------------------------------------------------------------
72 -- MR details rec. Used to capture detail of MRs added to a SR
73 ---------------------------------------------------------------------
74 TYPE MR_Association_Rec_Type IS RECORD (
75 MR_HEADER_ID NUMBER,
76 MR_TITLE VARCHAR2(80),
77 MR_VERSION NUMBER,
78 UE_RELATIONSHIP_ID NUMBER, -- OUT parameter for Create Operation
79 UNIT_EFFECTIVITY_ID NUMBER, -- OUT parameter for Create Operation
80 OBJECT_VERSION_NUMBER NUMBER, -- OVN of Unit Effectivity, Mandatory for Delete
81 RELATIONSHIP_CODE VARCHAR2(30), -- Always 'PARENT' or null
82 CSI_INSTANCE_ID NUMBER, -- Instance to which the MR is associated
83 CSI_INSTANCE_NUMBER VARCHAR2(30),
84 SR_TBL_INDEX NUMBER -- unique identifier linking MR to corresponding SR.
85 );
86
87 TYPE MR_Association_tbl_type IS TABLE OF MR_Association_Rec_Type INDEX BY BINARY_INTEGER;
88 -- MR NR ER -- End
89 -- MR NR ER -- Start
90 -------------------------------------------------------------------
91 -- Declare Procedures --
92 -------------------------------------------------------------------
93 -- Procedure name : Process_nonroutine_job
94 -- Type : Private
95 -- Function : To Create or Update Service request based on
96 -- operation_type and to create vwp task for
97 -- a nonroutine job.
98 -- Parameters :
99 --
100 -- Standard IN Parameters :
101 -- p_api_version IN NUMBER Required
102 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
103 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
105 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
106 -- p_module_type IN VARCHAR2 Default NULL.
107 --
108 -- Standard OUT Parameters :
109 -- x_return_status OUT VARCHAR2 Required
110 -- x_msg_count OUT NUMBER Required
111 -- x_msg_data OUT VARCHAR2 Required
112 --
113 -- Process_nonroutine_job Parameters:
114 -- p_x_sr_task_tbl IN OUT Sr_task_tbl Required
115 -- The table of records for creation / updation of Service
116 -- request and creation of vwp task.
117 -- p_x_mr_asso_tbl IN OUT MR_Association_tbl_type Required
118 -- The table of records containing MRs to be associated to the SR.
119 --
120 -- Version :
121 -- Initial Version 1.0
122 -------------------------------------------------------------------
123 PROCEDURE process_nonroutine_job (
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
126 p_commit IN VARCHAR2 := Fnd_Api.g_false,
127 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
128 p_module_type IN VARCHAR2 := 'JSP',
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
133 p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type
134 );
135 -- MR NR ER -- End
136 END;