DBA Data[Home] [Help]

APPS.MSC_CL_COLLECTION dependencies on MSC_COLLECTION_S

Line 1024: LCID= MSC_COLLECTION_S.NEXTVAL,

1020: RETCODE := MSC_UTIL.G_SUCCESS ;
1021:
1022: UPDATE MSC_APPS_INSTANCES
1023: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1024: LCID= MSC_COLLECTION_S.NEXTVAL,
1025: LAST_UPDATE_DATE= v_current_date,
1026: LAST_UPDATED_BY= v_current_user,
1027: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1028: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 1030: SELECT MSC_COLLECTION_S.CURRVAL

1026: LAST_UPDATED_BY= v_current_user,
1027: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1028: WHERE INSTANCE_ID= pINSTANCE_ID;
1029:
1030: SELECT MSC_COLLECTION_S.CURRVAL
1031: INTO v_last_collection_id
1032: FROM DUAL;
1033:
1034: RETURN TRUE;