APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1270: l_job_long_description po_requisition_lines_all.job_long_description%TYPE;

1266: FROM po_line_locations_interface plli
1267: WHERE plli.line_location_id <> p_line_location_id
1268: AND plli.interface_line_id = p_intf_line_id;
1269:
1270: l_job_long_description po_requisition_lines_all.job_long_description%TYPE;
1271: l_who_rec po_negotiations_sv2.who_rec_type;
1272: x_requisition_header_id NUMBER;
1273: x_column1 VARCHAR2 (10);
1274: l_pk2 VARCHAR2 (30);

Line 1465: FROM po_requisition_lines_all --

1461: -- Copy of the requisition header attachements to the purchase
1462: -- order line.
1463: SELECT requisition_header_id
1464: INTO x_requisition_header_id
1465: FROM po_requisition_lines_all --
1466: WHERE requisition_line_id = intf_rec.requisition_line_id;
1467:
1468: l_progress := '070';
1469: fnd_attached_documents2_pkg.copy_attachments

Line 1513: FROM po_requisition_lines_all --

1509: l_progress := '090';
1510:
1511: SELECT requisition_header_id
1512: INTO x_requisition_header_id
1513: FROM po_requisition_lines_all --
1514: WHERE requisition_line_id = intf_rec.requisition_line_id;
1515: ELSE
1516: x_column1 := 'NEG';
1517: END IF; -- attach_rec.requisition_line_id is not null

Line 2140: FROM po_requisition_lines_all prl,

2136:
2137: UPDATE po_lines_all pla
2138: SET pla.line_num_display =
2139: (SELECT prl.line_num_display
2140: FROM po_requisition_lines_all prl,
2141: po_lines_interface pli
2142: WHERE prl.requisition_line_id =
2143: pli.requisition_line_id
2144: AND pli.interface_header_id =