APPS.PO_AUTOCREATE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 363: from po_requisition_lines_all prl, po_requisition_headers_all prh

359: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
360: END IF;
361:
362: select prh.segment1||','||prl.line_num_display into l_requisition_number
363: from po_requisition_lines_all prl, po_requisition_headers_all prh
364: where prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
365: and prl.requisition_line_id = p_req_line_id;
366:
367: IF g_debug_stmt THEN

Line 1187: --Update po_line_id in po_requisition_lines_all after mod creation

1183: UPDATE po_headers_draft_all
1184: SET document_creation_method = 'PAR_AUTOCREATE'
1185: WHERE draft_id = p_mod_draft_id;
1186:
1187: --Update po_line_id in po_requisition_lines_all after mod creation
1188: UPDATE po_requisition_lines_all
1189: SET po_line_id = ( SELECT mod_line_id
1190: FROM po_lines_draft_all par, po_requisition_lines_all req
1191: WHERE req.par_line_id = p_par_line_tbl(i)

Line 1188: UPDATE po_requisition_lines_all

1184: SET document_creation_method = 'PAR_AUTOCREATE'
1185: WHERE draft_id = p_mod_draft_id;
1186:
1187: --Update po_line_id in po_requisition_lines_all after mod creation
1188: UPDATE po_requisition_lines_all
1189: SET po_line_id = ( SELECT mod_line_id
1190: FROM po_lines_draft_all par, po_requisition_lines_all req
1191: WHERE req.par_line_id = p_par_line_tbl(i)
1192: AND req.par_line_id = par.po_line_id

Line 1190: FROM po_lines_draft_all par, po_requisition_lines_all req

1186:
1187: --Update po_line_id in po_requisition_lines_all after mod creation
1188: UPDATE po_requisition_lines_all
1189: SET po_line_id = ( SELECT mod_line_id
1190: FROM po_lines_draft_all par, po_requisition_lines_all req
1191: WHERE req.par_line_id = p_par_line_tbl(i)
1192: AND req.par_line_id = par.po_line_id
1193: AND par.draft_id = p_par_draft_id_tbl(i)
1194: AND par.draft_id = req.par_draft_id

Line 1199: --Update req_distribution_id in po_requisition_lines_all after mod creation

1195: )
1196: WHERE par_line_id = p_par_line_tbl(i)
1197: AND par_draft_id = p_par_draft_id_tbl(i);
1198:
1199: --Update req_distribution_id in po_requisition_lines_all after mod creation
1200: BEGIN
1201: SELECT distribution_id, par_distribution_id
1202: BULK COLLECT INTO l_distribution_id_tbl, l_par_distribution_id_tbl
1203: FROM po_req_distributions_all prd, po_requisition_lines_all prl

Line 1203: FROM po_req_distributions_all prd, po_requisition_lines_all prl

1199: --Update req_distribution_id in po_requisition_lines_all after mod creation
1200: BEGIN
1201: SELECT distribution_id, par_distribution_id
1202: BULK COLLECT INTO l_distribution_id_tbl, l_par_distribution_id_tbl
1203: FROM po_req_distributions_all prd, po_requisition_lines_all prl
1204: WHERE prl.par_line_id = p_par_line_tbl(i)
1205: AND prl.par_draft_id = p_par_draft_id_tbl(i)
1206: AND prd.par_draft_id = prl.par_draft_id
1207: AND prl.requisition_line_id = prd.requisition_line_id;