DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PER_PEOPLE_F

Line 60: requestor per_people_f.full_name%TYPE,

56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);

Line 215: l_forwarded_from per_people_f.full_name%TYPE;

211: l_header_msg VARCHAR2(2225);
212: l_req_amount VARCHAR2(30);
213: l_tax_amount VARCHAR2(30);
214: l_description po_requisition_headers.description%TYPE;
215: l_forwarded_from per_people_f.full_name%TYPE;
216: l_preparer per_people_f.full_name%TYPE;
217: --
218: -- l_note VARCHAR2(480);
219: l_note po_action_history.note%TYPE;

Line 216: l_preparer per_people_f.full_name%TYPE;

212: l_req_amount VARCHAR2(30);
213: l_tax_amount VARCHAR2(30);
214: l_description po_requisition_headers.description%TYPE;
215: l_forwarded_from per_people_f.full_name%TYPE;
216: l_preparer per_people_f.full_name%TYPE;
217: --
218: -- l_note VARCHAR2(480);
219: l_note po_action_history.note%TYPE;
220: --

Line 460: l_approver per_people_f.full_name%TYPE;

456: l_header_msg VARCHAR2(200);
457: l_req_amount VARCHAR2(30);
458: l_tax_amount VARCHAR2(30);
459: l_description po_requisition_headers.description%TYPE;
460: l_approver per_people_f.full_name%TYPE;
461: l_preparer per_people_f.full_name%TYPE;
462: --
463: -- l_note VARCHAR2(480);
464: l_note po_action_history.note%TYPE;

Line 461: l_preparer per_people_f.full_name%TYPE;

457: l_req_amount VARCHAR2(30);
458: l_tax_amount VARCHAR2(30);
459: l_description po_requisition_headers.description%TYPE;
460: l_approver per_people_f.full_name%TYPE;
461: l_preparer per_people_f.full_name%TYPE;
462: --
463: -- l_note VARCHAR2(480);
464: l_note po_action_history.note%TYPE;
465: --

Line 730: l_approver per_people_f.full_name%TYPE;

726: l_header_msg VARCHAR2(200);
727: l_req_amount VARCHAR2(30);
728: l_tax_amount VARCHAR2(30);
729: l_description po_requisition_headers.description%TYPE;
730: l_approver per_people_f.full_name%TYPE;
731: l_preparer per_people_f.full_name%TYPE;
732: --
733: -- l_note VARCHAR2(480);
734: l_note po_action_history.note%TYPE;

Line 731: l_preparer per_people_f.full_name%TYPE;

727: l_req_amount VARCHAR2(30);
728: l_tax_amount VARCHAR2(30);
729: l_description po_requisition_headers.description%TYPE;
730: l_approver per_people_f.full_name%TYPE;
731: l_preparer per_people_f.full_name%TYPE;
732: --
733: -- l_note VARCHAR2(480);
734: l_note po_action_history.note%TYPE;
735: --

Line 955: l_rejected_by per_people_f.full_name%TYPE;

951: l_header_msg VARCHAR2(200);
952: l_req_amount VARCHAR2(30);
953: l_tax_amount VARCHAR2(30);
954: l_description po_requisition_headers.description%TYPE;
955: l_rejected_by per_people_f.full_name%TYPE;
956: l_preparer per_people_f.full_name%TYPE;
957: --
958: -- l_note VARCHAR2(480);
959: l_note po_action_history.note%TYPE;

Line 956: l_preparer per_people_f.full_name%TYPE;

952: l_req_amount VARCHAR2(30);
953: l_tax_amount VARCHAR2(30);
954: l_description po_requisition_headers.description%TYPE;
955: l_rejected_by per_people_f.full_name%TYPE;
956: l_preparer per_people_f.full_name%TYPE;
957: --
958: -- l_note VARCHAR2(480);
959: l_note po_action_history.note%TYPE;
960: --