DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on PO_LOOKUP_CODES

Line 40: l_document_subtype po_lookup_codes.displayed_field%TYPE;

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

Line 41: l_document_type po_lookup_codes.displayed_field%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);
45: l_req_amount VARCHAR2(30);

Line 216: l_document_subtype po_lookup_codes.displayed_field%TYPE;

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

Line 217: l_document_type po_lookup_codes.displayed_field%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);
221: l_req_amount VARCHAR2(30);

Line 398: l_document_subtype po_lookup_codes.displayed_field%TYPE;

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

Line 399: l_document_type po_lookup_codes.displayed_field%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);
403: l_header_msg VARCHAR2(200);

Line 579: l_document_subtype po_lookup_codes.displayed_field%TYPE;

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

Line 580: l_document_type po_lookup_codes.displayed_field%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);
584: l_header_msg VARCHAR2(200);

Line 1303: po_lookup_codes polc

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