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.PO_WF_REQ_NOTIFICATION dependencies on PO_REQUISITION_HEADERS

Line 204: l_document_id po_requisition_headers.requisition_header_id%TYPE;

200: max_seqno number;
201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;

Line 205: l_org_id po_requisition_headers.org_id%TYPE;

201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 208: l_document_number po_requisition_headers.segment1%TYPE;

204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);

Line 214: l_description po_requisition_headers.description%TYPE;

210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);
213: l_tax_amount VARCHAR2(30);
214: l_description po_requisition_headers.description%TYPE;
215: l_forwarded_from per_people_f.full_name%TYPE;
216: l_preparer per_people_f.full_name%TYPE;
217: --
218: -- l_note VARCHAR2(480);

Line 449: l_document_id po_requisition_headers.requisition_header_id%TYPE;

445: max_seqno number;
446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;

Line 450: l_org_id po_requisition_headers.org_id%TYPE;

446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 453: l_document_number po_requisition_headers.segment1%TYPE;

449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);

Line 459: l_description po_requisition_headers.description%TYPE;

455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);
458: l_tax_amount VARCHAR2(30);
459: l_description po_requisition_headers.description%TYPE;
460: l_approver per_people_f.full_name%TYPE;
461: l_preparer per_people_f.full_name%TYPE;
462: --
463: -- l_note VARCHAR2(480);

Line 719: l_document_id po_requisition_headers.requisition_header_id%TYPE;

715: max_seqno number;
716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;

Line 720: l_org_id po_requisition_headers.org_id%TYPE;

716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 723: l_document_number po_requisition_headers.segment1%TYPE;

719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);

Line 729: l_description po_requisition_headers.description%TYPE;

725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);
728: l_tax_amount VARCHAR2(30);
729: l_description po_requisition_headers.description%TYPE;
730: l_approver per_people_f.full_name%TYPE;
731: l_preparer per_people_f.full_name%TYPE;
732: --
733: -- l_note VARCHAR2(480);

Line 944: l_document_id po_requisition_headers.requisition_header_id%TYPE;

940: max_seqno number;
941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;

Line 945: l_org_id po_requisition_headers.org_id%TYPE;

941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 948: l_document_number po_requisition_headers.segment1%TYPE;

944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);

Line 954: l_description po_requisition_headers.description%TYPE;

950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);
953: l_tax_amount VARCHAR2(30);
954: l_description po_requisition_headers.description%TYPE;
955: l_rejected_by per_people_f.full_name%TYPE;
956: l_preparer per_people_f.full_name%TYPE;
957: --
958: -- l_note VARCHAR2(480);

Line 1412: l_req_status po_requisition_headers.authorization_status%TYPE;

1408: l_max_lines NUMBER := 0;
1409:
1410: l_document VARCHAR2(32000) := '';
1411:
1412: l_req_status po_requisition_headers.authorization_status%TYPE;
1413:
1414: l_req_details_url VARCHAR2(2000) := '';
1415: l_req_line_msg VARCHAR2(2000) := '';
1416: l_req_updates_url VARCHAR2(2000) := '';

Line 2577: l_req_header_id po_requisition_headers.requisition_header_id%TYPE;

2573: l_nid number;
2574: l_forwardTo varchar2(240);
2575: l_result varchar2(100);
2576: l_forward_to_username_response varchar2(240) :='';
2577: l_req_header_id po_requisition_headers.requisition_header_id%TYPE;
2578: l_action po_action_history.action_code%TYPE;
2579: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2580: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2581: l_origsys wf_roles.orig_system%TYPE;