DBA Data[Home] [Help]

APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_DESIGNATORS_S

Line 1167: Select MSC_DESIGNATORS_S.Nextval

1163: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1164: Exception
1165: when no_data_found
1166: then
1167: Select MSC_DESIGNATORS_S.Nextval
1168: into v_forecast_set_id
1169: from dual;
1170: End;
1171: Elsif c_rec.forecast_set is null then

Line 1238: ( MSC_DESIGNATORS_S.NEXTVAL,

1234: LAST_UPDATED_BY,
1235: CREATION_DATE,
1236: CREATED_BY)
1237: VALUES
1238: ( MSC_DESIGNATORS_S.NEXTVAL,
1239: v_forecast_Set_id,
1240: c_rec.DESIGNATOR,
1241: 6,
1242: c_rec.ORGANIZATION_ID,

Line 3165: ( MSC_DESIGNATORS_S.NEXTVAL,

3161: LAST_UPDATED_BY,
3162: CREATION_DATE,
3163: CREATED_BY)
3164: VALUES
3165: ( MSC_DESIGNATORS_S.NEXTVAL,
3166: c_rec.DESIGNATOR,
3167: c_rec.ORGANIZATION_ID,
3168: c_rec.MPS_RELIEF,
3169: c_rec.INVENTORY_ATP_FLAG,