APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_REQUISITION_LINES_ALL

Line 130: INSERT INTO po_requisition_lines_all

126: INTO l_req_line_id
127: FROM dual;
128:
129: -- INSERTING A REQ LINE RECORD FOR EACH LINE LEVEL CHANGE
130: INSERT INTO po_requisition_lines_all
131: (requisition_line_id,
132: requisition_header_id,
133: line_num,
134: line_type_id,

Line 353: -- PO REQUISITION LINES ALL.

349: END IF;
350: END LOOP;
351:
352: -- FOR HEADER LEVEL CHANGE WE NEED TO CREATE AN ADDITIONAL RECORD IN
353: -- PO REQUISITION LINES ALL.
354: INSERT INTO po_requisition_lines_all
355: (requisition_line_id,
356: requisition_header_id,
357: line_num,

Line 354: INSERT INTO po_requisition_lines_all

350: END LOOP;
351:
352: -- FOR HEADER LEVEL CHANGE WE NEED TO CREATE AN ADDITIONAL RECORD IN
353: -- PO REQUISITION LINES ALL.
354: INSERT INTO po_requisition_lines_all
355: (requisition_line_id,
356: requisition_header_id,
357: line_num,
358: line_type_id,

Line 402: FROM po_requisition_lines_all

398:
399: SELECT po_requisition_lines_s.NEXTVAL,
400: l_req_header_id,
401: (SELECT Nvl(Max(line_num), 0) + 1
402: FROM po_requisition_lines_all
403: WHERE requisition_header_id = l_req_header_id) LINE_NUM,
404: PLT.line_type_id,
405: NULL CATEGORY_ID,
406: pod.justification ITEM_DESCRIPTION,

Line 475: UPDATE po_requisition_lines_all prla1

471: END IF;
472:
473:
474: -- Rebuilding the Base to Option and Group line to Line mappings in Req lines
475: UPDATE po_requisition_lines_all prla1
476: SET clm_base_line_num = nvl((SELECT requisition_line_id
477: FROM po_requisition_lines_all prla2
478: WHERE prla2.par_line_id = prla1.clm_base_line_num
479: AND prla2.requisition_header_id

Line 477: FROM po_requisition_lines_all prla2

473:
474: -- Rebuilding the Base to Option and Group line to Line mappings in Req lines
475: UPDATE po_requisition_lines_all prla1
476: SET clm_base_line_num = nvl((SELECT requisition_line_id
477: FROM po_requisition_lines_all prla2
478: WHERE prla2.par_line_id = prla1.clm_base_line_num
479: AND prla2.requisition_header_id
480: = prla1.requisition_header_id),0) --bug 16483241
481: WHERE prla1.requisition_header_id = l_req_header_id

Line 485: UPDATE po_requisition_lines_all prla1

481: WHERE prla1.requisition_header_id = l_req_header_id
482: AND clm_base_line_num IS NOT NULL;
483:
484:
485: UPDATE po_requisition_lines_all prla1
486: SET group_line_id = nvl((SELECT requisition_line_id
487: FROM po_requisition_lines_all prla2
488: WHERE prla2.par_line_id = prla1.group_line_id
489: AND prla2.requisition_header_id

Line 487: FROM po_requisition_lines_all prla2

483:
484:
485: UPDATE po_requisition_lines_all prla1
486: SET group_line_id = nvl((SELECT requisition_line_id
487: FROM po_requisition_lines_all prla2
488: WHERE prla2.par_line_id = prla1.group_line_id
489: AND prla2.requisition_header_id
490: = prla1.requisition_header_id),0)--bug 16483241
491: WHERE prla1.requisition_header_id = l_req_header_id

Line 740: UPDATE po_requisition_lines_all

736: UPDATE po_requisition_headers_all
737: SET authorization_status = 'APPROVED'
738: WHERE requisition_header_id = l_par_req_header_id;
739:
740: UPDATE po_requisition_lines_all
741: SET reqs_in_pool_flag = 'Y'
742: WHERE requisition_header_id = l_par_req_header_id;
743:
744: COMMIT;