729: x_pk1_col_name := 'REQUISITION_HEADER_ID';
730: l_src_table_name := 'PO_REQUISITION_HEADERS_ALL';
731: ELSIF p_doc_level = 'LINE' THEN
732: x_pk1_col_name := 'REQUISITION_LINE_ID';
733: l_src_table_name := 'PO_REQUISITION_LINES_ALL';
734: END IF;
735:
736: ELSIF p_doc_type = 'IDV' THEN
737:
853:
854: l_progress := '080';
855: SELECT requisition_header_id
856: INTO x_pk1_value
857: FROM po_requisition_lines_all
858: WHERE requisition_line_id =(
859: SELECT requisition_line_id
860: FROM po_lines_interface
861: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
920: IF p_doc_level='HEADER' THEN
921: l_progress := '135';
922: SELECT requisition_header_id
923: INTO x_pk1_value
924: FROM po_requisition_lines_all
925: WHERE requisition_line_id =( SELECT requisition_line_id
926: FROM PO_LINES_INTERFACE
927: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
928: AND ROWNUM=1);
1914: END IF;
1915:
1916: ELSE
1917: l_progress := '080';
1918: l_src_template_id := get_template_id ('PO_REQUISITION_LINES_ALL'
1919: ,'REQUISITION_LINE_ID'
1920: ,l_src_rec.requisition_line_id
1921: ,NULL,
1922: NULL);