APPS.ITG_X_UTILS dependencies on PO_REQUISITION_HEADERS_ALL

Line 98: ** Return the distinct po_requisition_headers_all.segment1 for the

94: RETURN v_inv_org;
95: END get_inventory_org_id;
96:
97: /*
98: ** Return the distinct po_requisition_headers_all.segment1 for the
99: ** po_distributions_all.po_req_distribution_id. If segment1 is not
100: ** distinct for the input value, the first value selected is returned.
101: */
102: FUNCTION getRequistnid ( poReqDistId IN Number )

Line 104: returnValue po_requisition_headers_all.segment1%TYPE;

100: ** distinct for the input value, the first value selected is returned.
101: */
102: FUNCTION getRequistnid ( poReqDistId IN Number )
103: RETURN varchar2 AS
104: returnValue po_requisition_headers_all.segment1%TYPE;
105: CURSOR getSegment1 IS
106: SELECT reqHead.segment1
107: FROM po_requisition_headers_all reqHead,
108: po_requisition_lines_all reqLine,

Line 107: FROM po_requisition_headers_all reqHead,

103: RETURN varchar2 AS
104: returnValue po_requisition_headers_all.segment1%TYPE;
105: CURSOR getSegment1 IS
106: SELECT reqHead.segment1
107: FROM po_requisition_headers_all reqHead,
108: po_requisition_lines_all reqLine,
109: po_req_distributions_all reqDist
110: WHERE reqHead.requisition_header_id = reqLine.requisition_header_id
111: AND reqLine.requisition_line_id = reqDist.requisition_line_id

Line 127: returnValue po_requisition_headers_all.segment1%TYPE;

123: ** Given a po_req_distribution_id, return the line_num from po_requisition_lines_all
124: */
125: function getReqLineNum ( poReqDistId IN Number )
126: RETURN varchar2 AS
127: returnValue po_requisition_headers_all.segment1%TYPE;
128: CURSOR getLineNum IS
129: SELECT reqLine.line_num
130: FROM po_requisition_lines_all reqLine,
131: po_req_distributions_all reqDist