APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1212: FROM PO_LINE_LOCATIONS_draft_all

1208: PO_UDA_DEFAULTING_PKG.DEBUG('Draft Id is '|| p_draft_id, d_progress);
1209:
1210: SELECT UDA_TEMPLATE_ID
1211: INTO l_shipment_template_id
1212: FROM PO_LINE_LOCATIONS_draft_all
1213: WHERE LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID
1214: AND DRAFT_ID = p_draft_id;
1215:
1216: d_progress := 300;

Line 1330: FROM PO_LINE_LOCATIONS_DRAFT_ALL

1326: ,p_line_id NUMBER
1327: ,p_draft_id NUMBER
1328: )IS
1329: SELECT LINE_LOCATION_ID, SHIP_TO_LOCATION_ID
1330: FROM PO_LINE_LOCATIONS_DRAFT_ALL
1331: WHERE PO_HEADER_ID = p_po_header_id
1332: AND PO_LINE_ID = p_line_id
1333: AND DRAFT_ID = p_draft_id;
1334:

Line 1602: FROM PO_LINE_LOCATIONS_DRAFT_ALL

1598: PO_UDA_DEFAULTING_PKG.DEBUG('Draft Id is '|| p_draft_id, d_progress);
1599:
1600: SELECT UDA_TEMPLATE_ID
1601: INTO l_shipment_template_id
1602: FROM PO_LINE_LOCATIONS_DRAFT_ALL
1603: WHERE LINE_LOCATION_ID = c_get_shipments_rec.LINE_LOCATION_ID
1604: AND DRAFT_ID = p_draft_id;
1605: d_progress := 380;
1606: PO_UDA_DEFAULTING_PKG.DEBUG('l_line_template_id :' || l_shipment_template_id , d_progress);