DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on PO_REQUISITION_HEADERS

Line 38: l_document_id po_requisition_headers.requisition_header_id%TYPE;

34:
35: l_item_type wf_items.item_type%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;

Line 39: l_org_id po_requisition_headers.org_id%TYPE;

35: l_item_type wf_items.item_type%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;

Line 42: l_document_number po_requisition_headers.segment1%TYPE;

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);
46: l_description po_requisition_headers.description%TYPE;

Line 46: l_description po_requisition_headers.description%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);
46: l_description po_requisition_headers.description%TYPE;
47: l_approver per_people_f.full_name%TYPE;
48: l_preparer per_people_f.full_name%TYPE;
49: l_note VARCHAR2(240);
50:

Line 214: l_document_id po_requisition_headers.requisition_header_id%TYPE;

210:
211: l_item_type wf_items.item_type%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;

Line 215: l_org_id po_requisition_headers.org_id%TYPE;

211: l_item_type wf_items.item_type%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;

Line 218: l_document_number po_requisition_headers.segment1%TYPE;

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);
222: l_description po_requisition_headers.description%TYPE;

Line 222: l_description po_requisition_headers.description%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);
222: l_description po_requisition_headers.description%TYPE;
223: l_approver per_people_f.full_name%TYPE;
224: l_preparer per_people_f.full_name%TYPE;
225: l_note VARCHAR2(240);
226:

Line 396: l_document_id po_requisition_headers.requisition_header_id%TYPE;

392:
393: l_item_type wf_items.item_type%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;

Line 397: l_org_id po_requisition_headers.org_id%TYPE;

393: l_item_type wf_items.item_type%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;

Line 400: l_document_number po_requisition_headers.segment1%TYPE;

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);
404: l_description po_requisition_headers.description%TYPE;

Line 404: l_description po_requisition_headers.description%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);
404: l_description po_requisition_headers.description%TYPE;
405: l_approver per_people_f.full_name%TYPE;
406: l_preparer per_people_f.full_name%TYPE;
407: l_note VARCHAR2(240);
408:

Line 577: l_document_id po_requisition_headers.requisition_header_id%TYPE;

573:
574: l_item_type wf_items.item_type%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;

Line 578: l_org_id po_requisition_headers.org_id%TYPE;

574: l_item_type wf_items.item_type%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;

Line 581: l_document_number po_requisition_headers.segment1%TYPE;

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);
585: l_description po_requisition_headers.description%TYPE;

Line 585: l_description po_requisition_headers.description%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);
585: l_description po_requisition_headers.description%TYPE;
586: l_rejected_by per_people_f.full_name%TYPE;
587: l_preparer per_people_f.full_name%TYPE;
588: l_note VARCHAR2(240);
589: