APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_LOOKUP_CODES

Line 206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);

Line 207: l_document_type po_lookup_codes.displayed_field%TYPE;

203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
207: l_document_type po_lookup_codes.displayed_field%TYPE;
208: l_document_number po_requisition_headers.segment1%TYPE;
209: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
210: l_total_amount VARCHAR2(30);
211: l_header_msg VARCHAR2(2225);

Line 451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);

Line 452: l_document_type po_lookup_codes.displayed_field%TYPE;

448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
452: l_document_type po_lookup_codes.displayed_field%TYPE;
453: l_document_number po_requisition_headers.segment1%TYPE;
454: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
455: l_total_amount VARCHAR2(30);
456: l_header_msg VARCHAR2(200);

Line 721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);

Line 722: l_document_type po_lookup_codes.displayed_field%TYPE;

718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
722: l_document_type po_lookup_codes.displayed_field%TYPE;
723: l_document_number po_requisition_headers.segment1%TYPE;
724: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
725: l_total_amount VARCHAR2(30);
726: l_header_msg VARCHAR2(200);

Line 946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);

Line 947: l_document_type po_lookup_codes.displayed_field%TYPE;

943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;
947: l_document_type po_lookup_codes.displayed_field%TYPE;
948: l_document_number po_requisition_headers.segment1%TYPE;
949: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
950: l_total_amount VARCHAR2(30);
951: l_header_msg VARCHAR2(200);

Line 1918: po_lookup_codes polc

1914: poh.created_by, /* bug 2788683 */
1915: poh.action_code /* bug 3090563 */
1916: from po_action_history poh,
1917: per_all_people_f per, -- Bug 3404451
1918: po_lookup_codes polc
1919: where OBJECT_TYPE_CODE = v_object_type
1920: and nvl(poh.action_code, 'PENDING') = polc.lookup_code
1921: and POLC.LOOKUP_TYPE = 'APPR_HIST_ACTIONS'
1922: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 1939: po_lookup_codes polc

1935: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
1936: SELECT count(*)
1937: from po_action_history poh,
1938: per_all_people_f per,
1939: po_lookup_codes polc
1940: where OBJECT_TYPE_CODE = v_object_type
1941: and nvl(poh.action_code, 'PENDING') = polc.lookup_code
1942: and POLC.LOOKUP_TYPE = 'APPR_HIST_ACTIONS'
1943: and per.person_id(+) = poh.employee_id

Line 2348: po_lookup_codes polc

2344: poh.employee_id, /* bug 2788683 */
2345: poh.created_by /* bug 2788683 */
2346: from po_action_history poh,
2347: per_all_people_f per, -- Bug 3404451
2348: po_lookup_codes polc
2349: where OBJECT_TYPE_CODE = v_object_type
2350: and poh.action_code = polc.lookup_code
2351: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
2352: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 3211: from po_lookup_codes

3207: l_doc_subtype_disp varchar2(80);
3208:
3209: cursor c_doc_subtype(p_doc_subtype varchar2) is
3210: select DISPLAYED_FIELD
3211: from po_lookup_codes
3212: where lookup_type='REQUISITION TYPE'
3213: and lookup_code = p_doc_subtype;
3214:
3215: begin

Line 3234: from po_lookup_codes

3230: l_doc_type_disp varchar2(80);
3231:
3232: cursor c_doc_type(p_doc_type varchar2) is
3233: select DISPLAYED_FIELD
3234: from po_lookup_codes
3235: where lookup_type='DOCUMENT TYPE'
3236: and lookup_code = p_doc_type;
3237:
3238: begin