36: l_item_key wf_items.item_key%TYPE;
37:
38: l_document_id po_requisition_headers.requisition_header_id%TYPE;
39: l_org_id po_requisition_headers.org_id%TYPE;
40: l_document_subtype po_lookup_codes.displayed_field%TYPE;
41: l_document_type po_lookup_codes.displayed_field%TYPE;
42: l_document_number po_requisition_headers.segment1%TYPE;
43: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
44: l_header_msg VARCHAR2(200);
37:
38: l_document_id po_requisition_headers.requisition_header_id%TYPE;
39: l_org_id po_requisition_headers.org_id%TYPE;
40: l_document_subtype po_lookup_codes.displayed_field%TYPE;
41: l_document_type po_lookup_codes.displayed_field%TYPE;
42: l_document_number po_requisition_headers.segment1%TYPE;
43: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
44: l_header_msg VARCHAR2(200);
45: l_req_amount VARCHAR2(30);
212: l_item_key wf_items.item_key%TYPE;
213:
214: l_document_id po_requisition_headers.requisition_header_id%TYPE;
215: l_org_id po_requisition_headers.org_id%TYPE;
216: l_document_subtype po_lookup_codes.displayed_field%TYPE;
217: l_document_type po_lookup_codes.displayed_field%TYPE;
218: l_document_number po_requisition_headers.segment1%TYPE;
219: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
220: l_header_msg VARCHAR2(200);
213:
214: l_document_id po_requisition_headers.requisition_header_id%TYPE;
215: l_org_id po_requisition_headers.org_id%TYPE;
216: l_document_subtype po_lookup_codes.displayed_field%TYPE;
217: l_document_type po_lookup_codes.displayed_field%TYPE;
218: l_document_number po_requisition_headers.segment1%TYPE;
219: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
220: l_header_msg VARCHAR2(200);
221: l_req_amount VARCHAR2(30);
394: l_item_key wf_items.item_key%TYPE;
395:
396: l_document_id po_requisition_headers.requisition_header_id%TYPE;
397: l_org_id po_requisition_headers.org_id%TYPE;
398: l_document_subtype po_lookup_codes.displayed_field%TYPE;
399: l_document_type po_lookup_codes.displayed_field%TYPE;
400: l_document_number po_requisition_headers.segment1%TYPE;
401: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
402: l_req_amount VARCHAR2(30);
395:
396: l_document_id po_requisition_headers.requisition_header_id%TYPE;
397: l_org_id po_requisition_headers.org_id%TYPE;
398: l_document_subtype po_lookup_codes.displayed_field%TYPE;
399: l_document_type po_lookup_codes.displayed_field%TYPE;
400: l_document_number po_requisition_headers.segment1%TYPE;
401: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
402: l_req_amount VARCHAR2(30);
403: l_header_msg VARCHAR2(200);
575: l_item_key wf_items.item_key%TYPE;
576:
577: l_document_id po_requisition_headers.requisition_header_id%TYPE;
578: l_org_id po_requisition_headers.org_id%TYPE;
579: l_document_subtype po_lookup_codes.displayed_field%TYPE;
580: l_document_type po_lookup_codes.displayed_field%TYPE;
581: l_document_number po_requisition_headers.segment1%TYPE;
582: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
583: l_req_amount VARCHAR2(30);
576:
577: l_document_id po_requisition_headers.requisition_header_id%TYPE;
578: l_org_id po_requisition_headers.org_id%TYPE;
579: l_document_subtype po_lookup_codes.displayed_field%TYPE;
580: l_document_type po_lookup_codes.displayed_field%TYPE;
581: l_document_number po_requisition_headers.segment1%TYPE;
582: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
583: l_req_amount VARCHAR2(30);
584: l_header_msg VARCHAR2(200);
1299: poh.NOTE,
1300: poh.OBJECT_REVISION_NUM
1301: from po_action_history poh,
1302: per_people_f per,
1303: po_lookup_codes polc
1304: where OBJECT_TYPE_CODE = v_object_type
1305: and poh.action_code = polc.lookup_code
1306: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
1307: and per.person_id = poh.employee_id