APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_SUP_DEM_ENTRIES

Line 834: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;

830: a_order_rel_number end_order_rel_nums := end_order_rel_nums();
831:
832: a_request_date dates := dates();
833:
834: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;
835: l_lead_time NUMBER;
836: l_supplier_uom MSC_SUP_DEM_ENTRIES.TP_UOM_CODE%TYPE;
837: l_conversion_found BOOLEAN;
838: l_conversion_rate NUMBER;

Line 836: l_supplier_uom MSC_SUP_DEM_ENTRIES.TP_UOM_CODE%TYPE;

832: a_request_date dates := dates();
833:
834: l_supplier_item_name MSC_SUP_DEM_ENTRIES.SUPPLIER_ITEM_NAME%TYPE;
835: l_lead_time NUMBER;
836: l_supplier_uom MSC_SUP_DEM_ENTRIES.TP_UOM_CODE%TYPE;
837: l_conversion_found BOOLEAN;
838: l_conversion_rate NUMBER;
839: v_sql_stmt VARCHAR2(5000);
840: l_end_order_type_desc VARCHAR2(80);

Line 904: ' DELETE MSC_SUP_DEM_ENTRIES '

900: IF (p_collection_type = 'P' OR p_collection_type = 'C') THEN
901: BEGIN
902:
903: v_sql_stmt :=
904: ' DELETE MSC_SUP_DEM_ENTRIES '
905: ||' WHERE plan_id = -1'
906: ||' and customer_id = 1'
907: ||' and customer_site_id '|| p_in_org_str
908: ||' and ack_flag = '||'''Y'''

Line 917: LOG_MESSAGE('Error while deleting records from MSC_SUP_DEM_ENTRIES');

913: COMMIT;
914:
915: EXCEPTION WHEN OTHERS THEN
916:
917: LOG_MESSAGE('Error while deleting records from MSC_SUP_DEM_ENTRIES');
918: p_return_status := FALSE;
919: END;
920:
921: END IF;

Line 999: DELETE MSC_SUP_DEM_ENTRIES

995:
996: IF a_plan_id.COUNT > 0 THEN
997: BEGIN
998: FORALL i IN 1..a_plan_id.COUNT
999: DELETE MSC_SUP_DEM_ENTRIES
1000: WHERE plan_id = G_PLAN_ID
1001: and publisher_id = a_publisher_id(i)
1002: and publisher_site_id = a_publisher_site_id(i)
1003: and supplier_id = a_publisher_id(i)

Line 1123: INSERT INTO MSC_SUP_DEM_ENTRIES

1119: --========================
1120: IF a_plan_id.COUNT > 0 THEN
1121: BEGIN
1122: FORALL i IN 1..a_plan_id.COUNT
1123: INSERT INTO MSC_SUP_DEM_ENTRIES
1124: (
1125: -- Record keys / misc. columns
1126: transaction_id,
1127: plan_id ,

Line 1213: msc_sup_dem_entries_s.nextval,

1209: (
1210: -- ============================
1211: -- Record keys / misc. columns
1212: -- ============================
1213: msc_sup_dem_entries_s.nextval,
1214: a_plan_id(i),
1215: G_SR_INSTANCE_ID,
1216: msc_cl_refresh_s.nextval, --last_refresh_number,
1217: 'Y',

Line 1328: -- msc_sup_dem_entries. Now we will address rejected PO shipments by Supplier.

1324: END IF;
1325:
1326: -- ===========================================================================
1327: -- By this time we have collected PO supplies ans Supplier responses in
1328: -- msc_sup_dem_entries. Now we will address rejected PO shipments by Supplier.
1329: --
1330: -- We will bulk collect all rejected type of responses and then will bulk
1331: -- update msc_sup_dem_entries PO records with acceptance_required_flag = 'R'
1332: --

Line 1331: -- update msc_sup_dem_entries PO records with acceptance_required_flag = 'R'

1327: -- By this time we have collected PO supplies ans Supplier responses in
1328: -- msc_sup_dem_entries. Now we will address rejected PO shipments by Supplier.
1329: --
1330: -- We will bulk collect all rejected type of responses and then will bulk
1331: -- update msc_sup_dem_entries PO records with acceptance_required_flag = 'R'
1332: --
1333: -- This flag will be used by netting engine in order to generate PO rejected
1334: -- exception.
1335: -- ===========================================================================

Line 1370: UPDATE MSC_SUP_DEM_ENTRIES msde

1366: BEGIN
1367:
1368: FORALL i IN 1..a_plan_id.COUNT
1369:
1370: UPDATE MSC_SUP_DEM_ENTRIES msde
1371: SET acceptance_required_flag = 'R'
1372: where
1373: msde.publisher_id = a_customer_id(i)
1374: and msde.publisher_site_id = a_customer_site_id(i)