DBA Data[Home] [Help]

APPS.PO_WF_DOCUMENT dependencies on PO_REQUISITION_HEADERS

Line 37: l_document_id po_requisition_headers.requisition_header_id%TYPE;

33:
34: l_item_type wf_items.item_type%TYPE;
35: l_item_key wf_items.item_key%TYPE;
36:
37: l_document_id po_requisition_headers.requisition_header_id%TYPE;
38: l_org_id po_requisition_headers.org_id%TYPE;
39: l_document_subtype po_lookup_codes.displayed_field%TYPE;
40: l_document_type po_lookup_codes.displayed_field%TYPE;
41: l_document_number po_requisition_headers.segment1%TYPE;

Line 38: l_org_id po_requisition_headers.org_id%TYPE;

34: l_item_type wf_items.item_type%TYPE;
35: l_item_key wf_items.item_key%TYPE;
36:
37: l_document_id po_requisition_headers.requisition_header_id%TYPE;
38: l_org_id po_requisition_headers.org_id%TYPE;
39: l_document_subtype po_lookup_codes.displayed_field%TYPE;
40: l_document_type po_lookup_codes.displayed_field%TYPE;
41: l_document_number po_requisition_headers.segment1%TYPE;
42: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 41: l_document_number po_requisition_headers.segment1%TYPE;

37: l_document_id po_requisition_headers.requisition_header_id%TYPE;
38: l_org_id po_requisition_headers.org_id%TYPE;
39: l_document_subtype po_lookup_codes.displayed_field%TYPE;
40: l_document_type po_lookup_codes.displayed_field%TYPE;
41: l_document_number po_requisition_headers.segment1%TYPE;
42: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
43: l_total_amount VARCHAR2(30);
44: l_header_msg VARCHAR2(200);
45: l_req_amount VARCHAR2(30);

Line 47: l_description po_requisition_headers.description%TYPE;

43: l_total_amount VARCHAR2(30);
44: l_header_msg VARCHAR2(200);
45: l_req_amount VARCHAR2(30);
46: l_tax_amount VARCHAR2(30);
47: l_description po_requisition_headers.description%TYPE;
48: l_forwarded_from per_people_f.full_name%TYPE;
49: l_preparer per_people_f.full_name%TYPE;
50: l_note VARCHAR2(240);
51:

Line 252: l_document_id po_requisition_headers.requisition_header_id%TYPE;

248:
249: l_item_type wf_items.item_type%TYPE;
250: l_item_key wf_items.item_key%TYPE;
251:
252: l_document_id po_requisition_headers.requisition_header_id%TYPE;
253: l_org_id po_requisition_headers.org_id%TYPE;
254: l_document_subtype po_lookup_codes.displayed_field%TYPE;
255: l_document_type po_lookup_codes.displayed_field%TYPE;
256: l_document_number po_requisition_headers.segment1%TYPE;

Line 253: l_org_id po_requisition_headers.org_id%TYPE;

249: l_item_type wf_items.item_type%TYPE;
250: l_item_key wf_items.item_key%TYPE;
251:
252: l_document_id po_requisition_headers.requisition_header_id%TYPE;
253: l_org_id po_requisition_headers.org_id%TYPE;
254: l_document_subtype po_lookup_codes.displayed_field%TYPE;
255: l_document_type po_lookup_codes.displayed_field%TYPE;
256: l_document_number po_requisition_headers.segment1%TYPE;
257: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 256: l_document_number po_requisition_headers.segment1%TYPE;

252: l_document_id po_requisition_headers.requisition_header_id%TYPE;
253: l_org_id po_requisition_headers.org_id%TYPE;
254: l_document_subtype po_lookup_codes.displayed_field%TYPE;
255: l_document_type po_lookup_codes.displayed_field%TYPE;
256: l_document_number po_requisition_headers.segment1%TYPE;
257: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
258: l_total_amount VARCHAR2(30);
259: l_header_msg VARCHAR2(200);
260: l_req_amount VARCHAR2(30);

Line 262: l_description po_requisition_headers.description%TYPE;

258: l_total_amount VARCHAR2(30);
259: l_header_msg VARCHAR2(200);
260: l_req_amount VARCHAR2(30);
261: l_tax_amount VARCHAR2(30);
262: l_description po_requisition_headers.description%TYPE;
263: l_approver per_people_f.full_name%TYPE;
264: l_preparer per_people_f.full_name%TYPE;
265: l_note VARCHAR2(240);
266:

Line 457: l_document_id po_requisition_headers.requisition_header_id%TYPE;

453:
454: l_item_type wf_items.item_type%TYPE;
455: l_item_key wf_items.item_key%TYPE;
456:
457: l_document_id po_requisition_headers.requisition_header_id%TYPE;
458: l_org_id po_requisition_headers.org_id%TYPE;
459: l_document_subtype po_lookup_codes.displayed_field%TYPE;
460: l_document_type po_lookup_codes.displayed_field%TYPE;
461: l_document_number po_requisition_headers.segment1%TYPE;

Line 458: l_org_id po_requisition_headers.org_id%TYPE;

454: l_item_type wf_items.item_type%TYPE;
455: l_item_key wf_items.item_key%TYPE;
456:
457: l_document_id po_requisition_headers.requisition_header_id%TYPE;
458: l_org_id po_requisition_headers.org_id%TYPE;
459: l_document_subtype po_lookup_codes.displayed_field%TYPE;
460: l_document_type po_lookup_codes.displayed_field%TYPE;
461: l_document_number po_requisition_headers.segment1%TYPE;
462: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 461: l_document_number po_requisition_headers.segment1%TYPE;

457: l_document_id po_requisition_headers.requisition_header_id%TYPE;
458: l_org_id po_requisition_headers.org_id%TYPE;
459: l_document_subtype po_lookup_codes.displayed_field%TYPE;
460: l_document_type po_lookup_codes.displayed_field%TYPE;
461: l_document_number po_requisition_headers.segment1%TYPE;
462: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
463: l_total_amount VARCHAR2(30);
464: l_header_msg VARCHAR2(200);
465: l_req_amount VARCHAR2(30);

Line 467: l_description po_requisition_headers.description%TYPE;

463: l_total_amount VARCHAR2(30);
464: l_header_msg VARCHAR2(200);
465: l_req_amount VARCHAR2(30);
466: l_tax_amount VARCHAR2(30);
467: l_description po_requisition_headers.description%TYPE;
468: l_approver per_people_f.full_name%TYPE;
469: l_preparer per_people_f.full_name%TYPE;
470: l_note VARCHAR2(240);
471:

Line 662: l_document_id po_requisition_headers.requisition_header_id%TYPE;

658:
659: l_item_type wf_items.item_type%TYPE;
660: l_item_key wf_items.item_key%TYPE;
661:
662: l_document_id po_requisition_headers.requisition_header_id%TYPE;
663: l_org_id po_requisition_headers.org_id%TYPE;
664: l_document_subtype po_lookup_codes.displayed_field%TYPE;
665: l_document_type po_lookup_codes.displayed_field%TYPE;
666: l_document_number po_requisition_headers.segment1%TYPE;

Line 663: l_org_id po_requisition_headers.org_id%TYPE;

659: l_item_type wf_items.item_type%TYPE;
660: l_item_key wf_items.item_key%TYPE;
661:
662: l_document_id po_requisition_headers.requisition_header_id%TYPE;
663: l_org_id po_requisition_headers.org_id%TYPE;
664: l_document_subtype po_lookup_codes.displayed_field%TYPE;
665: l_document_type po_lookup_codes.displayed_field%TYPE;
666: l_document_number po_requisition_headers.segment1%TYPE;
667: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 666: l_document_number po_requisition_headers.segment1%TYPE;

662: l_document_id po_requisition_headers.requisition_header_id%TYPE;
663: l_org_id po_requisition_headers.org_id%TYPE;
664: l_document_subtype po_lookup_codes.displayed_field%TYPE;
665: l_document_type po_lookup_codes.displayed_field%TYPE;
666: l_document_number po_requisition_headers.segment1%TYPE;
667: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
668: l_total_amount VARCHAR2(30);
669: l_header_msg VARCHAR2(200);
670: l_req_amount VARCHAR2(30);

Line 672: l_description po_requisition_headers.description%TYPE;

668: l_total_amount VARCHAR2(30);
669: l_header_msg VARCHAR2(200);
670: l_req_amount VARCHAR2(30);
671: l_tax_amount VARCHAR2(30);
672: l_description po_requisition_headers.description%TYPE;
673: l_rejected_by per_people_f.full_name%TYPE;
674: l_preparer per_people_f.full_name%TYPE;
675: l_note VARCHAR2(240);
676: