DBA Data[Home] [Help]

APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINES_DRAFT_ALL

Line 1162: FROM po_lines_draft_all

1158: PO_UDA_DEFAULTING_PKG.DEBUG('Draft Id is '|| p_draft_id, d_progress);
1159:
1160: SELECT UDA_TEMPLATE_ID
1161: INTO l_line_template_id
1162: FROM po_lines_draft_all
1163: WHERE PO_LINE_ID = c_get_lines_rec.PO_LINE_ID
1164: AND DRAFT_ID = p_draft_id;
1165:
1166: d_progress := 200;

Line 1319: FROM PO_LINES_DRAFT_ALL

1315: p_po_header_id NUMBER
1316: ,p_draft_id NUMBER
1317: )IS
1318: SELECT PO_LINE_ID, ITEM_ID, LINE_TYPE_ID, CONTRACT_TYPE, CATEGORY_ID
1319: FROM PO_LINES_DRAFT_ALL
1320: WHERE PO_HEADER_ID = p_po_header_id
1321: AND DRAFT_ID = p_draft_id;
1322:
1323: CURSOR c_get_shipments

Line 1510: FROM PO_LINES_DRAFT_ALL

1506: PO_UDA_DEFAULTING_PKG.DEBUG('Draft Id is '|| p_draft_id, d_progress);
1507: d_progress := 240;
1508: SELECT UDA_TEMPLATE_ID
1509: INTO l_line_template_id
1510: FROM PO_LINES_DRAFT_ALL
1511: WHERE PO_LINE_ID = c_get_lines_rec.PO_LINE_ID
1512: AND DRAFT_ID = p_draft_id;
1513:
1514: d_progress := 250;