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