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.ASO_PA_APR_PUB_W dependencies on JTF_NUMBER_TABLE

Line 25: p_approval_det_id IN jtf_number_table := NULL,

21: RETURN n;
22: END;
23:
24: FUNCTION Construct_Approvers_List_Tbl(
25: p_approval_det_id IN jtf_number_table := NULL,
26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,

Line 26: p_object_approval_id IN jtf_number_table := NULL,

22: END;
23:
24: FUNCTION Construct_Approvers_List_Tbl(
25: p_approval_det_id IN jtf_number_table := NULL,
26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,

Line 27: p_approver_person_id IN jtf_number_table := NULL,

23:
24: FUNCTION Construct_Approvers_List_Tbl(
25: p_approval_det_id IN jtf_number_table := NULL,
26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,

Line 28: p_approver_user_id IN jtf_number_table := NULL,

24: FUNCTION Construct_Approvers_List_Tbl(
25: p_approval_det_id IN jtf_number_table := NULL,
26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,

Line 29: p_notification_id IN jtf_number_table := NULL,

25: p_approval_det_id IN jtf_number_table := NULL,
26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,

Line 30: p_approver_sequence IN jtf_number_table := NULL,

26: p_object_approval_id IN jtf_number_table := NULL,
27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,

Line 42: p_action_type_id IN jtf_number_table := NULL,

38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,

Line 43: p_chain_number IN jtf_number_table := NULL,

39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL

Line 44: p_occurrence IN jtf_number_table := NULL,

40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type

Line 185: x_approval_det_id OUT NOCOPY jtf_number_table,

181:
182:
183: PROCEDURE Set_Approvers_List_Tbl_Out(
184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,

Line 186: x_object_approval_id OUT NOCOPY jtf_number_table,

182:
183: PROCEDURE Set_Approvers_List_Tbl_Out(
184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,

Line 187: x_approver_person_id OUT NOCOPY jtf_number_table,

183: PROCEDURE Set_Approvers_List_Tbl_Out(
184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,

Line 188: x_approver_user_id OUT NOCOPY jtf_number_table,

184: p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,

Line 189: x_notification_id OUT NOCOPY jtf_number_table,

185: x_approval_det_id OUT NOCOPY jtf_number_table,
186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,

Line 190: x_approver_sequence OUT NOCOPY jtf_number_table,

186: x_object_approval_id OUT NOCOPY jtf_number_table,
187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

Line 202: x_action_type_id OUT NOCOPY jtf_number_table,

198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,

Line 203: x_chain_number OUT NOCOPY jtf_number_table,

199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,
207: x_date_received OUT NOCOPY jtf_date_table

Line 204: x_occurrence OUT NOCOPY jtf_number_table,

200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,
207: x_date_received OUT NOCOPY jtf_date_table
208: )

Line 212: x_approval_det_id := jtf_number_table();

208: )
209: AS
210: ddindx binary_integer; indx binary_integer;
211: BEGIN
212: x_approval_det_id := jtf_number_table();
213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();

Line 213: x_object_approval_id := jtf_number_table();

209: AS
210: ddindx binary_integer; indx binary_integer;
211: BEGIN
212: x_approval_det_id := jtf_number_table();
213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();

Line 214: x_approver_person_id := jtf_number_table();

210: ddindx binary_integer; indx binary_integer;
211: BEGIN
212: x_approval_det_id := jtf_number_table();
213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();

Line 215: x_approver_user_id := jtf_number_table();

211: BEGIN
212: x_approval_det_id := jtf_number_table();
213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();

Line 216: x_notification_id := jtf_number_table();

212: x_approval_det_id := jtf_number_table();
213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();

Line 217: x_approver_sequence := jtf_number_table();

213: x_object_approval_id := jtf_number_table();
214: x_approver_person_id := jtf_number_table();
215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();

Line 229: x_action_type_id := jtf_number_table();

225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();

Line 230: x_chain_number := jtf_number_table();

226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();
234: x_date_received := jtf_date_table();

Line 231: x_occurrence := jtf_number_table();

227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();
234: x_date_received := jtf_date_table();
235: IF p_qte_approvers_list_tbl.count > 0 THEN

Line 298: x_rule_id OUT NOCOPY jtf_number_table,

294:
295:
296: PROCEDURE Set_Rules_List_Tbl_Out(
297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
298: x_rule_id OUT NOCOPY jtf_number_table,
299: x_object_approval_id OUT NOCOPY jtf_number_table,
300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,

Line 299: x_object_approval_id OUT NOCOPY jtf_number_table,

295:
296: PROCEDURE Set_Rules_List_Tbl_Out(
297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
298: x_rule_id OUT NOCOPY jtf_number_table,
299: x_object_approval_id OUT NOCOPY jtf_number_table,
300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,

Line 300: x_rule_action_id OUT NOCOPY jtf_number_table,

296: PROCEDURE Set_Rules_List_Tbl_Out(
297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
298: x_rule_id OUT NOCOPY jtf_number_table,
299: x_object_approval_id OUT NOCOPY jtf_number_table,
300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,
304: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,

Line 310: x_rule_id := jtf_number_table();

306: )
307: AS
308: ddindx binary_integer; indx binary_integer;
309: BEGIN
310: x_rule_id := jtf_number_table();
311: x_object_approval_id := jtf_number_table();
312: x_rule_action_id := jtf_number_table();
313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();

Line 311: x_object_approval_id := jtf_number_table();

307: AS
308: ddindx binary_integer; indx binary_integer;
309: BEGIN
310: x_rule_id := jtf_number_table();
311: x_object_approval_id := jtf_number_table();
312: x_rule_action_id := jtf_number_table();
313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();
315: x_approval_level := jtf_varchar2_table_300();

Line 312: x_rule_action_id := jtf_number_table();

308: ddindx binary_integer; indx binary_integer;
309: BEGIN
310: x_rule_id := jtf_number_table();
311: x_object_approval_id := jtf_number_table();
312: x_rule_action_id := jtf_number_table();
313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();
315: x_approval_level := jtf_varchar2_table_300();
316: x_rule_item_class := jtf_varchar2_table_100();

Line 349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,

345: END Set_Rules_List_Tbl_Out;
346:
347:
348: PROCEDURE Get_All_Approvers(
349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,

Line 350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,

346:
347:
348: PROCEDURE Get_All_Approvers(
349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

Line 351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,

347:
348: PROCEDURE Get_All_Approvers(
349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,

Line 352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,

348: PROCEDURE Get_All_Approvers(
349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,

Line 353: x_qa_notification_id OUT NOCOPY jtf_number_table ,

349: x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,

Line 354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,

350: x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,

Line 366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,

362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,

Line 367: x_qa_chain_number OUT NOCOPY jtf_number_table ,

363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,

Line 368: x_qa_occurrence OUT NOCOPY jtf_number_table ,

364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,

Line 372: x_qr_rule_id OUT NOCOPY jtf_number_table ,

368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,

Line 373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

Line 374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,

370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,

Line 495: p_qa_approval_det_id IN jtf_number_table := NULL,

491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,

Line 496: p_qa_object_approval_id IN jtf_number_table := NULL,

492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,

Line 497: p_qa_approver_person_id IN jtf_number_table := NULL,

493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,

Line 498: p_qa_approver_user_id IN jtf_number_table := NULL,

494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,

Line 499: p_qa_notification_id IN jtf_number_table := NULL,

495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,

Line 500: p_qa_approver_sequence IN jtf_number_table := NULL,

496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,

Line 512: p_qa_action_type_id IN jtf_number_table := NULL,

508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,

Line 513: p_qa_chain_number IN jtf_number_table := NULL,

509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,
517: p_qa_date_received IN jtf_date_table := NULL,

Line 514: p_qa_occurrence IN jtf_number_table := NULL,

510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,
517: p_qa_date_received IN jtf_date_table := NULL,
518: x_object_approval_id OUT NOCOPY NUMBER,