DBA Data[Home] [Help]

APPS.PO_POXPRRFP_XMLP_PKG dependencies on PO_HEADERS

Line 112: UPDATE po_headers

108: if (check_security(poh_rfq_num) ) then
109: return FALSE ;
110: else
111: if P_test_flag <> 'Y' then
112: UPDATE po_headers
113: SET printed_date = sysdate
114: , print_count = nvl(print_count,0) + 1
115: , status_lookup_code = 'P'
116: WHERE po_header_id = poh_po_header_id;

Line 138: UPDATE po_headers

134: if (check_security(poh_rfq_num) ) then
135: return FALSE ;
136: else
137: if P_test_flag <> 'Y' then
138: UPDATE po_headers
139: SET printed_date = sysdate
140: , print_count = nvl(print_count,0) + 1
141: , status_lookup_code = 'P'
142: WHERE po_header_id = poh_po_header_id;

Line 190: from PO_HEADERS PH,

186: into l_dummy
187: from dual
188: where poh_rfq_num in
189: (select ph.segment1
190: from PO_HEADERS PH,
191: PO_DOCUMENT_TYPES_ALL_TL T, PO_DOCUMENT_TYPES_ALL_B B ,
192: fnd_user fnd,
193: po_system_parameters psp
194: WHERE fnd.user_id = P_user_id