1 PACKAGE jtf_am_wf_events_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfamwps.pls 120.2 2006/08/18 07:04:21 mpadhiar noship $ */
3
4 /*****************************************************************************************
5 ******************************************************************************************/
6
7 PROCEDURE assign_sr_resource
8 (P_API_VERSION IN NUMBER,
9 P_INIT_MSG_LIST IN VARCHAR2,
10 P_COMMIT IN VARCHAR2,
11 P_CONTRACT_ID IN NUMBER ,
12 P_CUSTOMER_PRODUCT_ID IN NUMBER ,
13 P_CATEGORY_ID IN NUMBER ,
14 P_INVENTORY_ITEM_ID IN NUMBER ,
15 P_INVENTORY_ORG_ID IN NUMBER ,
16 P_PROBLEM_CODE IN VARCHAR2 ,
17 P_SR_REC IN JTF_ASSIGN_PUB.JTF_SERV_REQ_REC_TYPE,
18 P_SR_TASK_REC IN JTF_ASSIGN_PUB.JTF_SRV_TASK_REC_TYPE,
19 P_BUSINESS_PROCESS_ID IN NUMBER,
20 P_BUSINESS_PROCESS_DATE IN DATE,
21 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22 X_MSG_COUNT OUT NOCOPY NUMBER,
23 X_MSG_DATA OUT NOCOPY VARCHAR2,
24 --Added for Bug # 5386560
25 P_INVENTORY_COMPONENT_ID IN NUMBER DEFAULT NULL
26 --Added for Bug # 5386560 Ends here
27 ) ;
28
29
30 /************** Added by SBARAT on 01/11/2004 for Enh-3919046 ****************/
31
32 PROCEDURE assign_dr_resource
33 (P_API_VERSION IN NUMBER,
34 P_INIT_MSG_LIST IN VARCHAR2,
35 P_COMMIT IN VARCHAR2,
36 P_CONTRACT_ID IN NUMBER ,
37 P_CUSTOMER_PRODUCT_ID IN NUMBER ,
38 P_CATEGORY_ID IN NUMBER ,
39 P_INVENTORY_ITEM_ID IN NUMBER ,
40 P_INVENTORY_ORG_ID IN NUMBER ,
41 P_PROBLEM_CODE IN VARCHAR2 ,
42 P_DR_REC IN JTF_ASSIGN_PUB.JTF_DR_REC_TYPE,
43 P_BUSINESS_PROCESS_ID IN NUMBER,
44 P_BUSINESS_PROCESS_DATE IN DATE,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46 X_MSG_COUNT OUT NOCOPY NUMBER,
47 X_MSG_DATA OUT NOCOPY VARCHAR2
48 ) ;
49
50 /************** End of addition by SBARAT on 01/11/2004 for Enh-3919046 ****************/
51
52
53 /************** Starting of Addition for Enh. No 3076744 by SBARAT, 13/09/2004 ****************/
54
55 PROCEDURE assign_task_resource
56 (P_API_VERSION IN NUMBER,
57 P_INIT_MSG_LIST IN VARCHAR2,
58 P_COMMIT IN VARCHAR2,
59 P_BUSINESS_PROCESS_ID IN NUMBER,
60 P_BUSINESS_PROCESS_DATE IN DATE,
61 P_TASK_ID IN JTF_TASKS_VL.TASK_ID%TYPE,
62 P_CONTRACT_ID IN NUMBER,
63 P_CUSTOMER_PRODUCT_ID IN NUMBER,
64 P_CATEGORY_ID IN NUMBER,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE assign_esc_resource
72 (P_API_VERSION IN NUMBER,
73 P_INIT_MSG_LIST IN VARCHAR2,
74 P_COMMIT IN VARCHAR2,
75 P_ESC_REC IN JTF_ASSIGN_PUB.Escalations_rec_type,
76 P_BUSINESS_PROCESS_ID IN NUMBER,
77 P_BUSINESS_PROCESS_DATE IN DATE,
78 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
79 X_MSG_COUNT OUT NOCOPY NUMBER,
80 X_MSG_DATA OUT NOCOPY VARCHAR2
81 );
82
83
84 PROCEDURE assign_def_resource
85 (P_API_VERSION IN NUMBER,
86 P_INIT_MSG_LIST IN VARCHAR2,
87 P_COMMIT IN VARCHAR2,
88 P_CONTRACT_ID IN NUMBER,
89 P_CUSTOMER_PRODUCT_ID IN NUMBER,
90 P_CATEGORY_ID IN NUMBER,
91 P_DEF_MGMT_REC IN JTF_ASSIGN_PUB.JTF_DEF_MGMT_rec_type,
92 P_BUSINESS_PROCESS_ID IN NUMBER,
93 P_BUSINESS_PROCESS_DATE IN DATE,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95 X_MSG_COUNT OUT NOCOPY NUMBER,
96 X_MSG_DATA OUT NOCOPY VARCHAR2
97 );
98
99
100 PROCEDURE assign_acc_resource
101 (P_API_VERSION IN NUMBER,
102 P_INIT_MSG_LIST IN VARCHAR2,
103 P_COMMIT IN VARCHAR2,
104 P_ACCOUNT_REC IN JTF_ASSIGN_PUB.JTF_Account_rec_type,
105 P_BUSINESS_PROCESS_ID IN NUMBER,
106 P_BUSINESS_PROCESS_DATE IN DATE,
107 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108 X_MSG_COUNT OUT NOCOPY NUMBER,
109 X_MSG_DATA OUT NOCOPY VARCHAR2
110 );
111
112
113 PROCEDURE assign_oppr_resource
114 (P_API_VERSION IN NUMBER,
115 P_INIT_MSG_LIST IN VARCHAR2,
116 P_COMMIT IN VARCHAR2,
117 P_OPPR_REC IN JTF_ASSIGN_PUB.JTF_Oppor_rec_type,
118 P_BUSINESS_PROCESS_ID IN NUMBER,
119 P_BUSINESS_PROCESS_DATE IN DATE,
120 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121 X_MSG_COUNT OUT NOCOPY NUMBER,
122 X_MSG_DATA OUT NOCOPY VARCHAR2
123 );
124
125
126 PROCEDURE assign_lead_resource
127 (P_API_VERSION IN NUMBER,
128 P_INIT_MSG_LIST IN VARCHAR2,
129 P_COMMIT IN VARCHAR2,
130 P_LEAD_REC IN JTF_ASSIGN_PUB.JTF_Lead_rec_type,
131 P_LEAD_BULK_REC IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
132 P_BUSINESS_PROCESS_ID IN NUMBER,
133 P_BUSINESS_PROCESS_DATE IN DATE,
134 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
135 X_MSG_COUNT OUT NOCOPY NUMBER,
136 X_MSG_DATA OUT NOCOPY VARCHAR2
137 );
138
139 /************** End of Addition for Enh. No 3076744 by SBARAT, 13/09/2004 ****************/
140
141 END jtf_am_wf_events_pub;