APPS.POR_UTIL_PKG dependencies on PO_HEADERS_ALL

Line 174: FROM po_headers_all WHERE po_header_id = p_header_id;

170:
171: FUNCTION getSitesEnabledFlagForContract(p_header_id in number) RETURN VARCHAR2 IS
172:
173: CURSOR C IS SELECT enable_all_sites
174: FROM po_headers_all WHERE po_header_id = p_header_id;
175: l_enable_all_sites PO_HEADERS_ALL.ENABLE_ALL_SITES%TYPE;
176:
177: BEGIN
178: OPEN C;

Line 175: l_enable_all_sites PO_HEADERS_ALL.ENABLE_ALL_SITES%TYPE;

171: FUNCTION getSitesEnabledFlagForContract(p_header_id in number) RETURN VARCHAR2 IS
172:
173: CURSOR C IS SELECT enable_all_sites
174: FROM po_headers_all WHERE po_header_id = p_header_id;
175: l_enable_all_sites PO_HEADERS_ALL.ENABLE_ALL_SITES%TYPE;
176:
177: BEGIN
178: OPEN C;
179: LOOP

Line 3950: FROM po_headers_all

3946: END;
3947: ELSE
3948:
3949: SELECT approved_flag INTO l_approved_flag
3950: FROM po_headers_all
3951: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = l_line_loc_id);
3952:
3953: IF(l_approved_flag = 'Y') THEN
3954: l_line_status := 'AWARD_APPROVED';

Line 4037: FROM po_headers_all

4033: l_line_status := 'AWARD_APPROVED';
4034: END;
4035: ELSE
4036: SELECT approved_flag INTO l_approved_flag
4037: FROM po_headers_all
4038: WHERE po_header_id = (SELECT po_header_id FROM po_line_locations_all WHERE line_location_id = c_get_req_details_rec.LINE_LOCATION_ID);
4039:
4040: IF(l_approved_flag = 'Y') THEN
4041: l_line_status := 'AWARD_APPROVED';

Line 4197: -- of DataRootElementProcessor with the value from po_headers_all if blanket

4193: -- Parameters : p_req_header_id IN NUMBER
4194: -- xUpdate_sourcing_rules_flag IN NUMBER
4195: -- xAuto_sourcing_rules_flag IN NUMBER
4196: -- Fixed Bug:10379671--fix the hard-coding done in START_PDOI_PROCESSING_PLSQL
4197: -- of DataRootElementProcessor with the value from po_headers_all if blanket
4198: -- already exists. Else, set it as 'N'.
4199: --
4200: -- This method is to get the value of the 2 flags used in
4201: -- DataRootElementProcessor

Line 4210: FROM po_headers_all

4206: BEGIN
4207:
4208: SELECT Nvl(update_sourcing_rules_flag,'N'), Nvl(auto_sourcing_flag,'N')
4209: INTO xUpdate_sourcing_rules_flag,xAuto_sourcing_flag
4210: FROM po_headers_all
4211: WHERE po_header_id = pHeaderId;
4212:
4213: EXCEPTION
4214: WHEN No_Data_Found THEN

Line 5949: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;

5945: l_notification_preference varchar2(20) := 'MAILHTM2';
5946: l_orgid number;
5947: l_operating_unit hr_all_organization_units.name%TYPE;
5948: l_document_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
5949: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
5950: l_release_num PO_RELEASES.release_num%TYPE;
5951: l_notification_id NUMBER;
5952: l_segment1 VARCHAR2(30);
5953: