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.POR_AME_REQ_WF_PVT dependencies on WF_ITEMS

Line 247: l_item_key wf_items.item_key%TYPE;

243: resultout out NOCOPY varchar2) IS
244:
245: l_progress VARCHAR2(500) := '000';
246: l_document_id number;
247: l_item_key wf_items.item_key%TYPE;
248: l_next_approver_id number;
249: l_next_approver_name per_employees_current_x.full_name%TYPE;
250: l_next_approver_user_name VARCHAR2(100);
251: l_next_approver_disp_name VARCHAR2(240);

Line 664: l_parent_item_type wf_items.parent_item_type%TYPE;

660: l_approver_posoition_id number;
661: l_approver_type varchar2(10);
662: l_error_code NUMBER;
663: l_error_message ame_util.longestStringType;
664: l_parent_item_type wf_items.parent_item_type%TYPE;
665: l_parent_item_key wf_items.parent_item_key%TYPE;
666: begin
667:
668: l_progress := 'Process_Response_Internal: 001';

Line 665: l_parent_item_key wf_items.parent_item_key%TYPE;

661: l_approver_type varchar2(10);
662: l_error_code NUMBER;
663: l_error_message ame_util.longestStringType;
664: l_parent_item_type wf_items.parent_item_type%TYPE;
665: l_parent_item_key wf_items.parent_item_key%TYPE;
666: begin
667:
668: l_progress := 'Process_Response_Internal: 001';
669: IF (g_po_wf_debug = 'Y') THEN

Line 756: FROM wf_items

752: l_error_message := SQLERRM;
753:
754: SELECT parent_item_type, parent_item_key
755: into l_parent_item_type, l_parent_item_key
756: FROM wf_items
757: WHERE item_type = itemtype and item_key = itemkey;
758:
759: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
760: itemkey => l_parent_item_key,

Line 799: l_parent_item_type wf_items.parent_item_type%TYPE;

795: funcmode in varchar2,
796: resultout out NOCOPY varchar2) IS
797:
798: l_progress VARCHAR2(500) := '000';
799: l_parent_item_type wf_items.parent_item_type%TYPE;
800: l_parent_item_key wf_items.parent_item_key%TYPE;
801:
802: l_child_approver_empid NUMBER;
803: l_child_approver_groupid NUMBER;

Line 800: l_parent_item_key wf_items.parent_item_key%TYPE;

796: resultout out NOCOPY varchar2) IS
797:
798: l_progress VARCHAR2(500) := '000';
799: l_parent_item_type wf_items.parent_item_type%TYPE;
800: l_parent_item_key wf_items.parent_item_key%TYPE;
801:
802: l_child_approver_empid NUMBER;
803: l_child_approver_groupid NUMBER;
804:

Line 822: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS

818: l_preparer_user_name fnd_user.user_name%TYPE;
819: l_doc_string VARCHAR2(200);
820: l_ame_exception ame_util.longestStringType;
821: l_approver_response varchar2(20);
822: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS
823: SELECT wfi.item_type, wfi.item_key
824: FROM wf_items wfi,wf_item_activity_statuses wfias
825: WHERE wfi.parent_item_key =itemkey
826: and wfi.item_type=itemtype

Line 824: FROM wf_items wfi,wf_item_activity_statuses wfias

820: l_ame_exception ame_util.longestStringType;
821: l_approver_response varchar2(20);
822: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS
823: SELECT wfi.item_type, wfi.item_key
824: FROM wf_items wfi,wf_item_activity_statuses wfias
825: WHERE wfi.parent_item_key =itemkey
826: and wfi.item_type=itemtype
827: AND wfias.item_type=wfi.item_type
828: AND wfias.item_key=wfi.item_key

Line 842: FROM wf_items

838: END IF;
839:
840: SELECT parent_item_type, parent_item_key
841: into l_parent_item_type, l_parent_item_key
842: FROM wf_items
843: WHERE item_type = itemtype and item_key = itemkey;
844:
845: /* Check if there we have encountered any ame exception.
846: If the value of ame_exception is not null, then we have faced some exception.

Line 1101: l_parent_item_type wf_items.parent_item_type%TYPE;

1097: funcmode in varchar2,
1098: resultout out NOCOPY varchar2) IS
1099:
1100: l_progress VARCHAR2(500) := '000';
1101: l_parent_item_type wf_items.parent_item_type%TYPE;
1102: l_parent_item_key wf_items.parent_item_key%TYPE;
1103:
1104: l_child_approver_empid number;
1105: l_child_approver_user_name wf_users.name%TYPE;

Line 1102: l_parent_item_key wf_items.parent_item_key%TYPE;

1098: resultout out NOCOPY varchar2) IS
1099:
1100: l_progress VARCHAR2(500) := '000';
1101: l_parent_item_type wf_items.parent_item_type%TYPE;
1102: l_parent_item_key wf_items.parent_item_key%TYPE;
1103:
1104: l_child_approver_empid number;
1105: l_child_approver_user_name wf_users.name%TYPE;
1106: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1117: FROM wf_items

1113: END IF;
1114:
1115: SELECT parent_item_type, parent_item_key
1116: into l_parent_item_type, l_parent_item_key
1117: FROM wf_items
1118: WHERE item_type = itemtype and item_key = itemkey;
1119:
1120: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
1121: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

Line 1208: l_parent_item_type wf_items.parent_item_type%TYPE;

1204: funcmode in varchar2,
1205: resultout out NOCOPY varchar2) IS
1206:
1207: l_progress VARCHAR2(500) := '000';
1208: l_parent_item_type wf_items.parent_item_type%TYPE;
1209: l_parent_item_key wf_items.parent_item_key%TYPE;
1210:
1211: l_child_approver_empid number;
1212: l_child_approver_user_name wf_users.name%TYPE;

Line 1209: l_parent_item_key wf_items.parent_item_key%TYPE;

1205: resultout out NOCOPY varchar2) IS
1206:
1207: l_progress VARCHAR2(500) := '000';
1208: l_parent_item_type wf_items.parent_item_type%TYPE;
1209: l_parent_item_key wf_items.parent_item_key%TYPE;
1210:
1211: l_child_approver_empid number;
1212: l_child_approver_user_name wf_users.name%TYPE;
1213: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1226: FROM wf_items

1222: Process_Response_Internal(itemtype, itemkey, 'REJECT');
1223:
1224: SELECT parent_item_type, parent_item_key
1225: into l_parent_item_type, l_parent_item_key
1226: FROM wf_items
1227: WHERE item_type = itemtype and item_key = itemkey;
1228:
1229: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1230: itemkey => l_parent_item_key,

Line 1322: l_parent_item_type wf_items.parent_item_type%TYPE;

1318: funcmode in varchar2,
1319: resultout out NOCOPY varchar2) IS
1320:
1321: l_progress VARCHAR2(500) := '000';
1322: l_parent_item_type wf_items.parent_item_type%TYPE;
1323: l_parent_item_key wf_items.parent_item_key%TYPE;
1324:
1325: l_child_approver_empid number;
1326: l_child_approver_user_name wf_users.name%TYPE;

Line 1323: l_parent_item_key wf_items.parent_item_key%TYPE;

1319: resultout out NOCOPY varchar2) IS
1320:
1321: l_progress VARCHAR2(500) := '000';
1322: l_parent_item_type wf_items.parent_item_type%TYPE;
1323: l_parent_item_key wf_items.parent_item_key%TYPE;
1324:
1325: l_child_approver_empid number;
1326: l_child_approver_user_name wf_users.name%TYPE;
1327: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1341: FROM wf_items

1337: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
1338:
1339: SELECT parent_item_type, parent_item_key
1340: into l_parent_item_type, l_parent_item_key
1341: FROM wf_items
1342: WHERE item_type = itemtype and item_key = itemkey;
1343:
1344: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1345: itemkey => l_parent_item_key,