APPS.PSP_ER_WORKFLOW dependencies on AME_UTIL

Line 602: l_next_approver ame_util.approversTable2;

598: wf_rname_array t1_varchar2;
599: app_order_num_array t_integer;
600: ame_txn_id_array t2_varchar2;
601: i integer;
602: l_next_approver ame_util.approversTable2;
603: l_wf_rname varchar2(320);
604: l_fork_flag varchar2(1);
605: l_request_id integer;
606: l_process_complete varchar2(10);

Line 914: approver_rec ame_util.approverRecord2;

910: l_initiator_rname wf_roles.name%type;
911: l_orig_system_id wf_roles.orig_system_id%type;
912: l_orig_system wf_roles.orig_system%type;
913: l_txn_id varchar2(50);
914: approver_rec ame_util.approverRecord2;
915: l_recipnt_role varchar2(300);
916:
917: cursor effort_report_id_cur is
918: select effort_report_id

Line 1145: approver_rec ame_util.approverRecord2;

1141: l_rname wf_roles.name%type;
1142: l_orig_system_id wf_roles.orig_system_id%type;
1143: l_orig_system wf_roles.orig_system%type;
1144: l_txn_id varchar2(50);
1145: approver_rec ame_util.approverRecord2;
1146: l_return_status CHAR(1);
1147:
1148: cursor get_orig_system is
1149: select wf_orig_system_id,

Line 1244: approver_rec.approval_status:= ame_util.approvedStatus;

1240:
1241: approver_rec.name := l_rname;
1242: approver_rec.orig_system := l_orig_system;
1243: approver_rec.orig_system_id := l_orig_system_id;
1244: approver_rec.approval_status:= ame_util.approvedStatus;
1245:
1246: open get_txn_id_cur;
1247: loop
1248: fetch get_txn_id_cur into l_txn_id;

Line 1289: approver_rec ame_util.approverRecord2;

1285: l_rname2 wf_roles.name%type;
1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);
1289: approver_rec ame_util.approverRecord2;
1290: forward_rec ame_util.approverRecord2;
1291: l_return_status CHAR(1);
1292:
1293: cursor get_orig_system is

Line 1290: forward_rec ame_util.approverRecord2;

1286: l_orig_system_id2 wf_roles.orig_system_id%type;
1287: l_orig_system2 wf_roles.orig_system%type;
1288: l_txn_id varchar2(50);
1289: approver_rec ame_util.approverRecord2;
1290: forward_rec ame_util.approverRecord2;
1291: l_return_status CHAR(1);
1292:
1293: cursor get_orig_system is
1294: select wf_orig_system_id,

Line 1510: approver_rec.approval_status:= ame_util.forwardStatus;

1506:
1507: approver_rec.name := l_rname;
1508: approver_rec.orig_system := l_orig_system;
1509: approver_rec.orig_system_id := l_orig_system_id;
1510: approver_rec.approval_status:= ame_util.forwardStatus;
1511: l_rname2 := wf_engine.context_text;
1512: l_nid := wf_engine.context_nid;
1513: open get_forwarde_details;
1514: fetch get_forwarde_details into l_orig_system2, l_orig_system_id2,l_role_display_name2;

Line 1520: forward_rec.approval_status:= ame_util.notifiedStatus;

1516: forward_rec.name := l_rname2;
1517: hr_utility.trace('post notification...Transfer . Forwardee='||l_rname2||' nid ='||l_nid);
1518: forward_rec.orig_system := l_orig_system2;
1519: forward_rec.orig_system_id := l_orig_system_id2;
1520: forward_rec.approval_status:= ame_util.notifiedStatus;
1521: update psp_eff_report_approvals
1522: set wf_role_name = l_rname2,
1523: wf_role_display_name = l_role_display_name2,
1524: wf_orig_system = l_orig_system2,