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_APPROVAL_LIST dependencies on PO_APPROVALLIST_S1

Line 29: p_approval_list IN OUT NOCOPY po_approvallist_s1.ApprovalListType);

25: --End of Comments
26: --------------------------------------------------------------------------------
27: procedure append_saved_adhoc_approver(
28: p_document_id IN NUMBER,
29: p_approval_list IN OUT NOCOPY po_approvallist_s1.ApprovalListType);
30:
31: PROCEDURE PushMessage(p_error_stack IN OUT NOCOPY /* file.sql.39 change */ po_approvallist_s1.ErrorStackType,
32: p_message_name IN VARCHAR2,
33: p_token1 IN VARCHAR2 DEFAULT NULL,

Line 31: PROCEDURE PushMessage(p_error_stack IN OUT NOCOPY /* file.sql.39 change */ po_approvallist_s1.ErrorStackType,

27: procedure append_saved_adhoc_approver(
28: p_document_id IN NUMBER,
29: p_approval_list IN OUT NOCOPY po_approvallist_s1.ApprovalListType);
30:
31: PROCEDURE PushMessage(p_error_stack IN OUT NOCOPY /* file.sql.39 change */ po_approvallist_s1.ErrorStackType,
32: p_message_name IN VARCHAR2,
33: p_token1 IN VARCHAR2 DEFAULT NULL,
34: p_value1 IN VARCHAR2 DEFAULT NULL,
35: p_token2 IN VARCHAR2 DEFAULT NULL,

Line 49: p_error_stack IN OUT NOCOPY /* file.sql.39 change */ po_approvallist_s1.ErrorStackType,

45: p_document_type IN VARCHAR2,
46: p_document_subtype IN VARCHAR2,
47: p_employee_id IN NUMBER,
48: p_return_code OUT NOCOPY /* file.sql.39 change */ NUMBER,
49: p_error_stack IN OUT NOCOPY /* file.sql.39 change */ po_approvallist_s1.ErrorStackType,
50: p_has_authority OUT NOCOPY /* file.sql.39 change */ BOOLEAN);
51:
52: PROCEDURE MarshalField(p_string IN VARCHAR2,
53: p_quote_char IN VARCHAR2,

Line 63: p_approval_list IN po_approvallist_s1.ApprovalListType,

59: p_remove_quotes IN BOOLEAN,
60: p_result OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
61: --Begin bug 13843060
62: FUNCTION is_adhoc_approver_exists(
63: p_approval_list IN po_approvallist_s1.ApprovalListType,
64: p_approver_id IN NUMBER) RETURN BOOLEAN;
65: --End bug 13843060
66: procedure get_doc_subtype(p_document_id in number) is
67:

Line 94: l_approval_list po_approvallist_s1.ApprovalListType;

90: p_preparer_can_approve OUT NOCOPY NUMBER,
91: p_append_saved_approver_flag IN NUMBER DEFAULT NULL,
92: p_checkout_flow_type IN VARCHAR2 DEFAULT NULL) IS
93:
94: l_approval_list po_approvallist_s1.ApprovalListType;
95: l_error_stack po_approvallist_s1.ErrorStackType;
96: l_return_code NUMBER;
97: l_last_update_date DATE;
98: l_approval_list_header_id NUMBER;

Line 95: l_error_stack po_approvallist_s1.ErrorStackType;

91: p_append_saved_approver_flag IN NUMBER DEFAULT NULL,
92: p_checkout_flow_type IN VARCHAR2 DEFAULT NULL) IS
93:
94: l_approval_list po_approvallist_s1.ApprovalListType;
95: l_error_stack po_approvallist_s1.ErrorStackType;
96: l_return_code NUMBER;
97: l_last_update_date DATE;
98: l_approval_list_header_id NUMBER;
99: l_index NUMBER;

Line 109: PO_APPROVALLIST_S1.g_checkout_flow_type := p_checkout_flow_type;

105: l_can_preparer_approve_flag VARCHAR2(1);
106: l_first_approver_id number;--bug 13843060
107: BEGIN
108:
109: PO_APPROVALLIST_S1.g_checkout_flow_type := p_checkout_flow_type;
110:
111: get_doc_subtype(p_document_id);
112:
113: p_approval_list_string := NULL;

Line 118: po_approvallist_s1.get_latest_approval_list

114:
115: IF (p_default_flag = 1) THEN
116: l_initial_build := true;
117: --begin bug 13843060
118: po_approvallist_s1.get_latest_approval_list
119: (p_document_id=>p_document_id,
120: p_document_type=>g_document_type,
121: p_document_subtype=>g_document_subtype,
122: p_return_code=>l_return_code,

Line 131: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN

127:
128: p_last_update_date := to_char(l_last_update_date, g_date_format_mask);
129: p_approval_list_header_id := l_approval_list_header_id;
130:
131: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN
132:
133: IF (l_error_stack.COUNT > 0) THEN
134: l_error_stack.delete;
135: END IF;

Line 157: po_approvallist_s1.get_default_approval_list(

153: END IF;
154:
155: l_first_approver_id := nvl(p_first_approver_id,l_first_approver_id);
156:
157: po_approvallist_s1.get_default_approval_list(
158: p_first_approver_id=>l_first_approver_id,
159: --End bug 13843060
160: p_approval_path_id=>NULL,
161: p_document_id=>p_document_id,

Line 176: po_approvallist_s1.rebuild_approval_list(

172: p_approval_list=>l_approval_list);
173: END IF;
174:
175: ELSIF (p_rebuild_flag = 1) THEN
176: po_approvallist_s1.rebuild_approval_list(
177: p_document_id=>p_document_id,
178: p_document_type=>g_document_type,
179: p_document_subtype=>g_document_subtype,
180: p_rebuild_code=>'DOCUMENT_CHANGED',

Line 185: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN

181: p_return_code=>l_return_code,
182: p_error_stack=>l_error_stack,
183: p_approval_list_header_id=>l_approval_list_header_id);
184:
185: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN
186: GOTO HANDLE_ERROR; -- bad style huh?
187: END IF;
188: po_approvallist_s1.get_latest_approval_list
189: (p_document_id=>p_document_id,

Line 188: po_approvallist_s1.get_latest_approval_list

184:
185: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN
186: GOTO HANDLE_ERROR; -- bad style huh?
187: END IF;
188: po_approvallist_s1.get_latest_approval_list
189: (p_document_id=>p_document_id,
190: p_document_type=>g_document_type,
191: p_document_subtype=>g_document_subtype,
192: p_return_code=>l_return_code,

Line 201: po_approvallist_s1.get_latest_approval_list

197:
198: p_last_update_date := to_char(l_last_update_date, g_date_format_mask);
199: p_approval_list_header_id := l_approval_list_header_id;
200: ELSE
201: po_approvallist_s1.get_latest_approval_list
202: (p_document_id=>p_document_id,
203: p_document_type=>g_document_type,
204: p_document_subtype=>g_document_subtype,
205: p_return_code=>l_return_code,

Line 214: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN

210:
211: p_last_update_date := to_char(l_last_update_date, g_date_format_mask);
212: p_approval_list_header_id := l_approval_list_header_id;
213:
214: IF (l_return_code <> po_approvallist_s1.E_SUCCESS) THEN
215:
216: IF (l_error_stack.COUNT > 0) THEN
217: l_error_stack.delete;
218: END IF;

Line 221: po_approvallist_s1.get_default_approval_list

217: l_error_stack.delete;
218: END IF;
219:
220: l_initial_build := true;
221: po_approvallist_s1.get_default_approval_list
222: ( p_first_approver_id=>p_first_approver_id,
223: p_approval_path_id=>NULL,
224: p_document_id=>p_document_id,
225: p_document_type=>g_document_type,

Line 235: IF (l_return_code = po_approvallist_s1.E_SUCCESS) THEN

231:
232: END IF;
233: END IF;
234:
235: IF (l_return_code = po_approvallist_s1.E_SUCCESS) THEN
236:
237: g_approval_list_string := NULL;
238:
239: IF (l_approval_list.COUNT > 0) THEN

Line 313: IF (l_approval_return_code <> po_approvallist_s1.E_SUCCESS) THEN

309: p_return_code=>l_approval_return_code,
310: p_error_stack=>l_error_stack,
311: p_has_authority=>l_has_authority);
312:
313: IF (l_approval_return_code <> po_approvallist_s1.E_SUCCESS) THEN
314: p_preparer_can_approve := 0;
315: ELSIF (l_has_authority) THEN
316: p_preparer_can_approve := 1;
317: ELSE

Line 329: ELSIF (p_default_flag = 1 AND l_return_code = po_approvallist_s1.E_NO_ONE_HAS_AUTHORITY) THEN

325:
326: RETURN;
327:
328:
329: ELSIF (p_default_flag = 1 AND l_return_code = po_approvallist_s1.E_NO_ONE_HAS_AUTHORITY) THEN
330:
331: SELECT NVL(can_preparer_approve_flag, 'N')
332: INTO l_can_preparer_approve_flag
333: FROM po_document_types podt

Line 355: IF (l_approval_return_code <> po_approvallist_s1.E_SUCCESS) THEN

351: p_return_code=>l_approval_return_code,
352: p_error_stack=>l_error_stack,
353: p_has_authority=>l_has_authority);
354:
355: IF (l_approval_return_code <> po_approvallist_s1.E_SUCCESS) THEN
356: p_preparer_can_approve := 0;
357: ELSIF (l_has_authority) THEN
358: p_preparer_can_approve := 1;
359: ELSE

Line 407: PO_APPROVALLIST_S1.g_checkout_flow_type := '';

403: ELSE
404: p_return_code := 1;
405: END IF;
406:
407: PO_APPROVALLIST_S1.g_checkout_flow_type := '';
408:
409: END get_approval_list;
410:
411: PROCEDURE save_approval_list(p_document_id IN NUMBER,

Line 420: l_approval_list po_approvallist_s1.ApprovalListType;

416: p_quote_char IN VARCHAR2,
417: p_field_delimiter IN VARCHAR2,
418: p_return_code OUT NOCOPY NUMBER,
419: p_error_stack_string OUT NOCOPY VARCHAR2) IS
420: l_approval_list po_approvallist_s1.ApprovalListType;
421: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;
422: l_error_stack po_approvallist_s1.ErrorStackType;
423: l_index NUMBER;
424: l_pos NUMBER;

Line 421: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;

417: p_field_delimiter IN VARCHAR2,
418: p_return_code OUT NOCOPY NUMBER,
419: p_error_stack_string OUT NOCOPY VARCHAR2) IS
420: l_approval_list po_approvallist_s1.ApprovalListType;
421: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;
422: l_error_stack po_approvallist_s1.ErrorStackType;
423: l_index NUMBER;
424: l_pos NUMBER;
425: l_string VARCHAR2(32767);

Line 422: l_error_stack po_approvallist_s1.ErrorStackType;

418: p_return_code OUT NOCOPY NUMBER,
419: p_error_stack_string OUT NOCOPY VARCHAR2) IS
420: l_approval_list po_approvallist_s1.ApprovalListType;
421: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;
422: l_error_stack po_approvallist_s1.ErrorStackType;
423: l_index NUMBER;
424: l_pos NUMBER;
425: l_string VARCHAR2(32767);
426: l_last_update_date DATE;

Line 634: -- debug: po_approvallist_s1.print_approval_list(l_approval_list);

630: l_approval_list(l_index) := l_approval_list_elt;
631:
632: END LOOP;
633:
634: -- debug: po_approvallist_s1.print_approval_list(l_approval_list);
635:
636: po_approvallist_s1.save_approval_list(
637: p_document_id=>p_document_id,
638: p_document_type=>g_document_type,

Line 636: po_approvallist_s1.save_approval_list(

632: END LOOP;
633:
634: -- debug: po_approvallist_s1.print_approval_list(l_approval_list);
635:
636: po_approvallist_s1.save_approval_list(
637: p_document_id=>p_document_id,
638: p_document_type=>g_document_type,
639: p_document_subtype=>g_document_subtype,
640: p_first_approver_id=>p_first_approver_id,

Line 648: IF (l_return_code = po_approvallist_s1.E_SUCCESS) THEN

644: p_approval_list_header_id=> p_approval_list_header_id,
645: p_return_code=>l_return_code,
646: p_error_stack=>l_error_stack);
647:
648: IF (l_return_code = po_approvallist_s1.E_SUCCESS) THEN
649: p_return_code := 1;
650:
651: select to_char(last_update_date, g_date_format_mask) into p_last_update_date
652: from po_approval_list_headers

Line 696: PO_APPROVALLIST_S1.UPDATE_APPROVAL_LIST_ITEMKEY(p_document_id,

692: SET wf_item_type = 'REQAPPRV',
693: wf_item_key = l_wf_item_key
694: WHERE requisition_header_id = p_document_id;
695:
696: PO_APPROVALLIST_S1.UPDATE_APPROVAL_LIST_ITEMKEY(p_document_id,
697: 'REQAPPRV',
698: l_wf_item_key,
699: l_return);
700:

Line 771: p_error_stack IN OUT NOCOPY po_approvallist_s1.ErrorStackType,

767: p_document_type IN VARCHAR2,
768: p_document_subtype IN VARCHAR2,
769: p_employee_id IN NUMBER,
770: p_return_code OUT NOCOPY NUMBER,
771: p_error_stack IN OUT NOCOPY po_approvallist_s1.ErrorStackType,
772: p_has_authority OUT NOCOPY BOOLEAN) IS
773:
774: l_progress VARCHAR2(10) := '000';
775: l_return_value NUMBER;

Line 814: p_return_code := po_approvallist_s1.E_DOC_MGR_TIMEOUT;

810: END IF;
811: p_return_code := 0;
812: ELSE
813: IF (l_return_value = 1) THEN
814: p_return_code := po_approvallist_s1.E_DOC_MGR_TIMEOUT;
815: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);
816: ELSIF (l_return_value = 2) THEN
817: p_return_code := po_approvallist_s1.E_DOC_MGR_NOMGR;
818: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);

Line 817: p_return_code := po_approvallist_s1.E_DOC_MGR_NOMGR;

813: IF (l_return_value = 1) THEN
814: p_return_code := po_approvallist_s1.E_DOC_MGR_TIMEOUT;
815: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);
816: ELSIF (l_return_value = 2) THEN
817: p_return_code := po_approvallist_s1.E_DOC_MGR_NOMGR;
818: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);
819: ELSE
820: p_return_code := po_approvallist_s1.E_DOC_MGR_OTHER;
821: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);

Line 820: p_return_code := po_approvallist_s1.E_DOC_MGR_OTHER;

816: ELSIF (l_return_value = 2) THEN
817: p_return_code := po_approvallist_s1.E_DOC_MGR_NOMGR;
818: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);
819: ELSE
820: p_return_code := po_approvallist_s1.E_DOC_MGR_OTHER;
821: PushMessage(p_error_stack, 'PO_ALIST_DOC_MGR_FAIL', 'ERR_CODE', l_return_value);
822: END IF;
823: END IF;
824:

Line 831: PROCEDURE PushMessage(p_error_stack IN OUT NOCOPY po_approvallist_s1.ErrorStackType,

827: p_return_code := SQLCODE;
828: PushMessage(p_error_stack, 'PO_ALL_SQL_ERROR', 'ROUTINE', 'VerifyAuthority', 'ERR_NUMBER', l_progress, 'SQL_ERR', SQLERRM(SQLCODE));
829: END VerifyAuthority;
830:
831: PROCEDURE PushMessage(p_error_stack IN OUT NOCOPY po_approvallist_s1.ErrorStackType,
832: p_message_name IN VARCHAR2,
833: p_token1 IN VARCHAR2 DEFAULT NULL,
834: p_value1 IN VARCHAR2 DEFAULT NULL,
835: p_token2 IN VARCHAR2 DEFAULT NULL,

Line 1075: p_approval_list IN OUT NOCOPY po_approvallist_s1.ApprovalListType) IS

1071: end;
1072:
1073: procedure append_saved_adhoc_approver(
1074: p_document_id IN NUMBER,
1075: p_approval_list IN OUT NOCOPY po_approvallist_s1.ApprovalListType) IS
1076:
1077: l_approver_id number;
1078:
1079: cursor adhoc_approver_c IS

Line 1097: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;

1093:
1094: l_index NUMBER;
1095: l_username wf_users.name%TYPE;
1096: l_disp_name wf_users.display_name%TYPE;
1097: l_approval_list_elt po_approvallist_s1.ApprovalListEltType;
1098:
1099: BEGIN
1100: l_index := p_approval_list.LAST;
1101: IF (l_index IS NULL) THEN

Line 1139: p_approval_list IN po_approvallist_s1.ApprovalListType,

1135: END;
1136:
1137: --Begin bug 13843060
1138: FUNCTION is_adhoc_approver_exists(
1139: p_approval_list IN po_approvallist_s1.ApprovalListType,
1140: p_approver_id IN NUMBER) RETURN BOOLEAN IS
1141: BEGIN
1142: for i in Nvl(p_approval_list.first,0) .. Nvl(p_approval_list.last,-1) loop
1143: if(p_approval_list(i).approver_id = p_approver_id) then