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;
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;
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);
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:
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;
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;
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);
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:
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;
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;
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);
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:
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;
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;
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);
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: