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 898: approver_rec ame_util.approverRecord2;

894: l_initiator_rname wf_roles.name%type;
895: l_orig_system_id wf_roles.orig_system_id%type;
896: l_orig_system wf_roles.orig_system%type;
897: l_txn_id varchar2(50);
898: approver_rec ame_util.approverRecord2;
899: l_recipnt_role varchar2(300);
900:
901: cursor effort_report_id_cur is
902: select effort_report_id

Line 1129: approver_rec ame_util.approverRecord2;

1125: l_rname wf_roles.name%type;
1126: l_orig_system_id wf_roles.orig_system_id%type;
1127: l_orig_system wf_roles.orig_system%type;
1128: l_txn_id varchar2(50);
1129: approver_rec ame_util.approverRecord2;
1130: l_return_status CHAR(1);
1131:
1132: cursor get_orig_system is
1133: select wf_orig_system_id,

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

1208:
1209: approver_rec.name := l_rname;
1210: approver_rec.orig_system := l_orig_system;
1211: approver_rec.orig_system_id := l_orig_system_id;
1212: approver_rec.approval_status:= ame_util.approvedStatus;
1213:
1214: open get_txn_id_cur;
1215: loop
1216: fetch get_txn_id_cur into l_txn_id;

Line 1257: approver_rec ame_util.approverRecord2;

1253: l_rname2 wf_roles.name%type;
1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);
1257: approver_rec ame_util.approverRecord2;
1258: forward_rec ame_util.approverRecord2;
1259: l_return_status CHAR(1);
1260:
1261: cursor get_orig_system is

Line 1258: forward_rec ame_util.approverRecord2;

1254: l_orig_system_id2 wf_roles.orig_system_id%type;
1255: l_orig_system2 wf_roles.orig_system%type;
1256: l_txn_id varchar2(50);
1257: approver_rec ame_util.approverRecord2;
1258: forward_rec ame_util.approverRecord2;
1259: l_return_status CHAR(1);
1260:
1261: cursor get_orig_system is
1262: select wf_orig_system_id,

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

1466:
1467: approver_rec.name := l_rname;
1468: approver_rec.orig_system := l_orig_system;
1469: approver_rec.orig_system_id := l_orig_system_id;
1470: approver_rec.approval_status:= ame_util.forwardStatus;
1471: l_rname2 := wf_engine.context_text;
1472: l_nid := wf_engine.context_nid;
1473: open get_forwarde_details;
1474: fetch get_forwarde_details into l_orig_system2, l_orig_system_id2,l_role_display_name2;

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

1476: forward_rec.name := l_rname2;
1477: hr_utility.trace('post notification...Transfer . Forwardee='||l_rname2||' nid ='||l_nid);
1478: forward_rec.orig_system := l_orig_system2;
1479: forward_rec.orig_system_id := l_orig_system_id2;
1480: forward_rec.approval_status:= ame_util.notifiedStatus;
1481: update psp_eff_report_approvals
1482: set wf_role_name = l_rname2,
1483: wf_role_display_name = l_role_display_name2,
1484: wf_orig_system = l_orig_system2,