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;
43: l_total_amount VARCHAR2(30);
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;
43: l_total_amount VARCHAR2(30);
44: l_header_msg VARCHAR2(200);
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;
258: l_total_amount VARCHAR2(30);
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;
258: l_total_amount VARCHAR2(30);
259: l_header_msg VARCHAR2(200);
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;
463: l_total_amount VARCHAR2(30);
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;
463: l_total_amount VARCHAR2(30);
464: l_header_msg VARCHAR2(200);
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;
668: l_total_amount VARCHAR2(30);
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;
668: l_total_amount VARCHAR2(30);
669: l_header_msg VARCHAR2(200);
1039: poh.NOTE,
1040: poh.OBJECT_REVISION_NUM
1041: from po_action_history poh,
1042: per_people_f per,
1043: po_lookup_codes polc
1044: where OBJECT_TYPE_CODE = v_object_type
1045: and poh.action_code = polc.lookup_code
1046: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
1047: and per.person_id = poh.employee_id