APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_DESIGNATORS_S

Line 1229: Select MSC_DESIGNATORS_S.Nextval

1225: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1226: Exception
1227: when no_data_found
1228: then
1229: Select MSC_DESIGNATORS_S.Nextval
1230: into v_forecast_set_id
1231: from dual;
1232: End;
1233: Elsif c_rec.forecast_set is null then

Line 1300: ( MSC_DESIGNATORS_S.NEXTVAL,

1296: LAST_UPDATED_BY,
1297: CREATION_DATE,
1298: CREATED_BY)
1299: VALUES
1300: ( MSC_DESIGNATORS_S.NEXTVAL,
1301: v_forecast_Set_id,
1302: c_rec.DESIGNATOR,
1303: 6,
1304: c_rec.ORGANIZATION_ID,

Line 1513: ( MSC_DESIGNATORS_S.NEXTVAL,

1509: LAST_UPDATED_BY,
1510: CREATION_DATE,
1511: CREATED_BY)
1512: VALUES
1513: ( MSC_DESIGNATORS_S.NEXTVAL,
1514: c_rec.SRC_SIM_FCST_ID,
1515: c_rec.DESIGNATOR,
1516: c_rec.SRC_DESIGNATOR,
1517: c_rec.SRC_DESCRIPTION,

Line 3523: ( MSC_DESIGNATORS_S.NEXTVAL,

3519: LAST_UPDATED_BY,
3520: CREATION_DATE,
3521: CREATED_BY)
3522: VALUES
3523: ( MSC_DESIGNATORS_S.NEXTVAL,
3524: c_rec.DESIGNATOR,
3525: c_rec.ORGANIZATION_ID,
3526: c_rec.MPS_RELIEF,
3527: c_rec.INVENTORY_ATP_FLAG,