APPS.QPR_DEAL_APPROVALS_PVT dependencies on AME_UTIL

Line 59: function get_approval_record(p_ame_record ame_util.approverRecord2)

55: procedure update_with_ame(p_response_header_id in number,
56: p_user_id in number,
57: p_action in varchar2);
58:
59: function get_approval_record(p_ame_record ame_util.approverRecord2)
60: return approval_record_type;
61:
62: function is_approvals_changed(p_response_header_id in number,
63: p_ame_approvals_tab in approval_table_type)

Line 102: function get_approval_record(p_ame_record ame_util.approverRecord2)

98: and archive_flag = 'N'
99: and approver_id <> p_user_id;
100: end clear_existing_approvals;
101:
102: function get_approval_record(p_ame_record ame_util.approverRecord2)
103: return approval_record_type
104: is
105: l_approver_rec approval_record_type;
106: l_fnd_user_id number;

Line 178: l_ame_next_approver_tab ame_util.approversTable2;

174: is
175: l_count number;
176: l_notify_flag varchar2(1);
177: l_approvals_complete varchar2(1);
178: l_ame_next_approver_tab ame_util.approversTable2;
179: l_approver_record ame_util.approverRecord2;
180:
181: cursor get_active_records(c_resp_id number)
182: is

Line 179: l_approver_record ame_util.approverRecord2;

175: l_count number;
176: l_notify_flag varchar2(1);
177: l_approvals_complete varchar2(1);
178: l_ame_next_approver_tab ame_util.approversTable2;
179: l_approver_record ame_util.approverRecord2;
180:
181: cursor get_active_records(c_resp_id number)
182: is
183: select approver_name, approval_status

Line 198: l_notify_flag := ame_util.booleanTrue;

194: and approval_status in ('NOTIFIED', 'APPROVE');
195:
196: if l_count > 0
197: then
198: l_notify_flag := ame_util.booleanTrue;
199: ame_api2.getNextApprovers4(
200: applicationIdIn => get_application_id(),
201: transactionTypeIn => g_transaction_type_id,
202: transactionIdIn => p_response_header_id,

Line 267: l_ame_approver_table ame_util.approversTable2;

263: x_approvals_complete out nocopy varchar2)
264: is
265: l_transaction_id varchar2(50);
266: l_notify_flag varchar2(1);
267: l_ame_approver_table ame_util.approversTable2;
268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;

Line 268: l_ame_next_approver_tab ame_util.approversTable2;

264: is
265: l_transaction_id varchar2(50);
266: l_notify_flag varchar2(1);
267: l_ame_approver_table ame_util.approversTable2;
268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;

Line 269: l_ame_item_indexes ame_util.idlist;

265: l_transaction_id varchar2(50);
266: l_notify_flag varchar2(1);
267: l_ame_approver_table ame_util.approversTable2;
268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;

Line 270: l_ame_item_classes ame_util.stringlist;

266: l_notify_flag varchar2(1);
267: l_ame_approver_table ame_util.approversTable2;
268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;

Line 271: l_ame_item_ids ame_util.stringlist;

267: l_ame_approver_table ame_util.approversTable2;
268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;

Line 272: l_ame_item_sources ame_util.longstringlist;

268: l_ame_next_approver_tab ame_util.approversTable2;
269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;
276: l_ame_rule_descs ame_util.stringlist;

Line 273: l_ame_rule_indexes ame_util.idlist;

269: l_ame_item_indexes ame_util.idlist;
270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;
276: l_ame_rule_descs ame_util.stringlist;
277: l_approval_rec approval_record_type;

Line 274: l_ame_source_types ame_util.stringlist;

270: l_ame_item_classes ame_util.stringlist;
271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;
276: l_ame_rule_descs ame_util.stringlist;
277: l_approval_rec approval_record_type;
278:

Line 275: l_ame_rule_ids ame_util.idlist;

271: l_ame_item_ids ame_util.stringlist;
272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;
276: l_ame_rule_descs ame_util.stringlist;
277: l_approval_rec approval_record_type;
278:
279: begin

Line 276: l_ame_rule_descs ame_util.stringlist;

272: l_ame_item_sources ame_util.longstringlist;
273: l_ame_rule_indexes ame_util.idlist;
274: l_ame_source_types ame_util.stringlist;
275: l_ame_rule_ids ame_util.idlist;
276: l_ame_rule_descs ame_util.stringlist;
277: l_approval_rec approval_record_type;
278:
279: begin
280:

Line 282: l_notify_flag := ame_util.booleanFalse;

278:
279: begin
280:
281: l_transaction_id := p_response_header_id;
282: l_notify_flag := ame_util.booleanFalse;
283:
284:
285:
286: ame_api2.getAllApprovers6(

Line 363: l_ame_approver_table ame_util.approversTable2;

359: is
360: l_transaction_id varchar2(50);
361: l_notify_flag varchar2(1);
362: l_approvals_complete varchar2(1);
363: l_ame_approver_table ame_util.approversTable2;
364: l_count number;
365:
366: begin
367:

Line 369: l_notify_flag := ame_util.booleanFalse;

365:
366: begin
367:
368: l_transaction_id := p_response_header_id;
369: l_notify_flag := ame_util.booleanFalse;
370:
371: ame_api2.getNextApprovers4(
372: applicationIdIn => get_application_id(),
373: transactionTypeIn => g_transaction_type_id,

Line 397: l_notify_flag := ame_util.booleanTrue;

393:
394: end loop;
395: end if;
396:
397: l_notify_flag := ame_util.booleanTrue;
398: ame_api2.getNextApprovers4(
399: applicationIdIn => get_application_id(),
400: transactionTypeIn => g_transaction_type_id,
401: transactionIdIn => l_transaction_id,

Line 415: l_ame_approver_table ame_util.approversTable2;

411: p_status in varchar2,
412: x_prior_approvals_tab out nocopy approval_table_type,
413: x_approvals_complete out nocopy varchar2)
414: is
415: l_ame_approver_table ame_util.approversTable2;
416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;

Line 416: l_ame_item_indexes ame_util.idlist;

412: x_prior_approvals_tab out nocopy approval_table_type,
413: x_approvals_complete out nocopy varchar2)
414: is
415: l_ame_approver_table ame_util.approversTable2;
416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;

Line 417: l_ame_item_classes ame_util.stringlist;

413: x_approvals_complete out nocopy varchar2)
414: is
415: l_ame_approver_table ame_util.approversTable2;
416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;

Line 418: l_ame_item_ids ame_util.stringlist;

414: is
415: l_ame_approver_table ame_util.approversTable2;
416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;

Line 419: l_ame_item_sources ame_util.longstringlist;

415: l_ame_approver_table ame_util.approversTable2;
416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;
423: l_ame_rule_descs ame_util.stringlist;

Line 420: l_ame_rule_indexes ame_util.idlist;

416: l_ame_item_indexes ame_util.idlist;
417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;
423: l_ame_rule_descs ame_util.stringlist;
424: l_approval_rec approval_record_type;

Line 421: l_ame_source_types ame_util.stringlist;

417: l_ame_item_classes ame_util.stringlist;
418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;
423: l_ame_rule_descs ame_util.stringlist;
424: l_approval_rec approval_record_type;
425: l_approvals_tab approval_table_type;

Line 422: l_ame_rule_ids ame_util.idlist;

418: l_ame_item_ids ame_util.stringlist;
419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;
423: l_ame_rule_descs ame_util.stringlist;
424: l_approval_rec approval_record_type;
425: l_approvals_tab approval_table_type;
426: l_user_name varchar2(320);

Line 423: l_ame_rule_descs ame_util.stringlist;

419: l_ame_item_sources ame_util.longstringlist;
420: l_ame_rule_indexes ame_util.idlist;
421: l_ame_source_types ame_util.stringlist;
422: l_ame_rule_ids ame_util.idlist;
423: l_ame_rule_descs ame_util.stringlist;
424: l_approval_rec approval_record_type;
425: l_approvals_tab approval_table_type;
426: l_user_name varchar2(320);
427: l_approver_record ame_util.approverRecord2;

Line 427: l_approver_record ame_util.approverRecord2;

423: l_ame_rule_descs ame_util.stringlist;
424: l_approval_rec approval_record_type;
425: l_approvals_tab approval_table_type;
426: l_user_name varchar2(320);
427: l_approver_record ame_util.approverRecord2;
428:
429: l_index number;
430: l_rule_ids id_list;
431: l_rule_count number;

Line 532: l_ame_approver_table ame_util.approversTable2;

528: procedure clear_ame_status(p_response_header_id in number,
529: p_user_id in number,
530: x_cleared_approvals_tab out nocopy approval_table_type)
531: is
532: l_ame_approver_table ame_util.approversTable2;
533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;

Line 533: l_ame_rec ame_util.approverRecord2;

529: p_user_id in number,
530: x_cleared_approvals_tab out nocopy approval_table_type)
531: is
532: l_ame_approver_table ame_util.approversTable2;
533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;

Line 534: l_ame_item_indexes ame_util.idlist;

530: x_cleared_approvals_tab out nocopy approval_table_type)
531: is
532: l_ame_approver_table ame_util.approversTable2;
533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;

Line 535: l_ame_item_classes ame_util.stringlist;

531: is
532: l_ame_approver_table ame_util.approversTable2;
533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;

Line 536: l_ame_item_ids ame_util.stringlist;

532: l_ame_approver_table ame_util.approversTable2;
533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;

Line 537: l_ame_item_sources ame_util.longstringlist;

533: l_ame_rec ame_util.approverRecord2;
534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;
541: l_ame_rule_descs ame_util.stringlist;

Line 538: l_ame_rule_indexes ame_util.idlist;

534: l_ame_item_indexes ame_util.idlist;
535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;
541: l_ame_rule_descs ame_util.stringlist;
542: l_rule_id number;

Line 539: l_ame_source_types ame_util.stringlist;

535: l_ame_item_classes ame_util.stringlist;
536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;
541: l_ame_rule_descs ame_util.stringlist;
542: l_rule_id number;
543: l_item_class varchar2(100);

Line 540: l_ame_rule_ids ame_util.idlist;

536: l_ame_item_ids ame_util.stringlist;
537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;
541: l_ame_rule_descs ame_util.stringlist;
542: l_rule_id number;
543: l_item_class varchar2(100);
544: l_item_id varchar2(100);

Line 541: l_ame_rule_descs ame_util.stringlist;

537: l_ame_item_sources ame_util.longstringlist;
538: l_ame_rule_indexes ame_util.idlist;
539: l_ame_source_types ame_util.stringlist;
540: l_ame_rule_ids ame_util.idlist;
541: l_ame_rule_descs ame_util.stringlist;
542: l_rule_id number;
543: l_item_class varchar2(100);
544: l_item_id varchar2(100);
545: l_approvals_complete varchar2(1);

Line 871: l_ame_approver_table ame_util.approversTable2;

867: procedure update_with_ame(p_response_header_id in number,
868: p_user_id in number,
869: p_action in varchar2)
870: is
871: l_ame_approver_table ame_util.approversTable2;
872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;

Line 872: l_ame_item_indexes ame_util.idlist;

868: p_user_id in number,
869: p_action in varchar2)
870: is
871: l_ame_approver_table ame_util.approversTable2;
872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;

Line 873: l_ame_item_classes ame_util.stringlist;

869: p_action in varchar2)
870: is
871: l_ame_approver_table ame_util.approversTable2;
872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;

Line 874: l_ame_item_ids ame_util.stringlist;

870: is
871: l_ame_approver_table ame_util.approversTable2;
872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;

Line 875: l_ame_item_sources ame_util.longstringlist;

871: l_ame_approver_table ame_util.approversTable2;
872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;
879: l_ame_rule_descs ame_util.stringlist;

Line 876: l_ame_rule_indexes ame_util.idlist;

872: l_ame_item_indexes ame_util.idlist;
873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;
879: l_ame_rule_descs ame_util.stringlist;
880: l_approval_rec approval_record_type;

Line 877: l_ame_source_types ame_util.stringlist;

873: l_ame_item_classes ame_util.stringlist;
874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;
879: l_ame_rule_descs ame_util.stringlist;
880: l_approval_rec approval_record_type;
881: l_approvals_tab approval_table_type;

Line 878: l_ame_rule_ids ame_util.idlist;

874: l_ame_item_ids ame_util.stringlist;
875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;
879: l_ame_rule_descs ame_util.stringlist;
880: l_approval_rec approval_record_type;
881: l_approvals_tab approval_table_type;
882: l_approvals_complete varchar2(1);

Line 879: l_ame_rule_descs ame_util.stringlist;

875: l_ame_item_sources ame_util.longstringlist;
876: l_ame_rule_indexes ame_util.idlist;
877: l_ame_source_types ame_util.stringlist;
878: l_ame_rule_ids ame_util.idlist;
879: l_ame_rule_descs ame_util.stringlist;
880: l_approval_rec approval_record_type;
881: l_approvals_tab approval_table_type;
882: l_approvals_complete varchar2(1);
883:

Line 1315: l_ame_rec ame_util.approverRecord2;

1311: where response_header_id = c_Response_header_id
1312: order by archive_flag,approval_transaction_id;
1313:
1314: l_approvals_complete varchar2(1);
1315: l_ame_rec ame_util.approverRecord2;
1316: l_approvals_tab approval_table_type;
1317: l_count number;
1318:
1319: begin

Line 1452: l_ame_approver_table ame_util.approversTable2;

1448: IS
1449: l_application_id number;
1450: l_transaction_id varchar2(50);
1451: l_approval_complete_flag varchar2(10);
1452: l_ame_approver_table ame_util.approversTable2;
1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;

Line 1453: l_itemIndexesOut ame_util.idList;

1449: l_application_id number;
1450: l_transaction_id varchar2(50);
1451: l_approval_complete_flag varchar2(10);
1452: l_ame_approver_table ame_util.approversTable2;
1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;

Line 1454: l_itemClassesOut ame_util.stringList;

1450: l_transaction_id varchar2(50);
1451: l_approval_complete_flag varchar2(10);
1452: l_ame_approver_table ame_util.approversTable2;
1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;

Line 1455: l_itemIdsOut ame_util.stringList;

1451: l_approval_complete_flag varchar2(10);
1452: l_ame_approver_table ame_util.approversTable2;
1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;
1459: l_ruleDescriptionsOut ame_util.stringList;

Line 1456: l_itemSourcesOut ame_util.longStringList;

1452: l_ame_approver_table ame_util.approversTable2;
1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;
1459: l_ruleDescriptionsOut ame_util.stringList;
1460: l_rules_desc varchar2(1000);

Line 1457: l_ruleIndexesOut ame_util.idList;

1453: l_itemIndexesOut ame_util.idList;
1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;
1459: l_ruleDescriptionsOut ame_util.stringList;
1460: l_rules_desc varchar2(1000);
1461: l_count number;

Line 1458: l_sourceTypesOut ame_util.stringList;

1454: l_itemClassesOut ame_util.stringList;
1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;
1459: l_ruleDescriptionsOut ame_util.stringList;
1460: l_rules_desc varchar2(1000);
1461: l_count number;
1462: BEGIN

Line 1459: l_ruleDescriptionsOut ame_util.stringList;

1455: l_itemIdsOut ame_util.stringList;
1456: l_itemSourcesOut ame_util.longStringList;
1457: l_ruleIndexesOut ame_util.idList;
1458: l_sourceTypesOut ame_util.stringList;
1459: l_ruleDescriptionsOut ame_util.stringList;
1460: l_rules_desc varchar2(1000);
1461: l_count number;
1462: BEGIN
1463: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1485: approversOut out nocopy ame_util.approversTable2,

1481: /* applicationIdIn in number,
1482: transactionTypeIn in varchar2,
1483: transactionIdIn in varchar2,
1484: approvalProcessCompleteYNOut out nocopy varchar2,
1485: approversOut out nocopy ame_util.approversTable2,
1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,

Line 1486: itemIndexesOut out nocopy ame_util.idList,

1482: transactionTypeIn in varchar2,
1483: transactionIdIn in varchar2,
1484: approvalProcessCompleteYNOut out nocopy varchar2,
1485: approversOut out nocopy ame_util.approversTable2,
1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,

Line 1487: itemClassesOut out nocopy ame_util.stringList,

1483: transactionIdIn in varchar2,
1484: approvalProcessCompleteYNOut out nocopy varchar2,
1485: approversOut out nocopy ame_util.approversTable2,
1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,

Line 1488: itemIdsOut out nocopy ame_util.stringList,

1484: approvalProcessCompleteYNOut out nocopy varchar2,
1485: approversOut out nocopy ame_util.approversTable2,
1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,
1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/

Line 1489: itemSourcesOut out nocopy ame_util.longStringList,

1485: approversOut out nocopy ame_util.approversTable2,
1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,
1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/
1493: if(l_ame_approver_table.count > 0) then

Line 1490: ruleIndexesOut out nocopy ame_util.idList,

1486: itemIndexesOut out nocopy ame_util.idList,
1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,
1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/
1493: if(l_ame_approver_table.count > 0) then
1494: o_comply := 'N';

Line 1491: sourceTypesOut out nocopy ame_util.stringList,

1487: itemClassesOut out nocopy ame_util.stringList,
1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,
1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/
1493: if(l_ame_approver_table.count > 0) then
1494: o_comply := 'N';
1495: l_count := 0;

Line 1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/

1488: itemIdsOut out nocopy ame_util.stringList,
1489: itemSourcesOut out nocopy ame_util.longStringList,
1490: ruleIndexesOut out nocopy ame_util.idList,
1491: sourceTypesOut out nocopy ame_util.stringList,
1492: ruleDescriptionsOut out nocopy ame_util.stringList)*/
1493: if(l_ame_approver_table.count > 0) then
1494: o_comply := 'N';
1495: l_count := 0;
1496: for i in l_ruleDescriptionsOut.first .. l_ruleDescriptionsOut.last loop