DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_COLLECTION_S

Line 57678: LCID= MSC_COLLECTION_S.NEXTVAL,

57674: RETCODE := G_SUCCESS;
57675:
57676: UPDATE MSC_APPS_INSTANCES
57677: SET ST_STATUS= G_ST_PRE_PROCESSING,
57678: LCID= MSC_COLLECTION_S.NEXTVAL,
57679: LAST_UPDATE_DATE= v_current_date,
57680: LAST_UPDATED_BY= v_current_user,
57681: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
57682: WHERE INSTANCE_ID= p_instance_id;

Line 57684: SELECT MSC_COLLECTION_S.CURRVAL

57680: LAST_UPDATED_BY= v_current_user,
57681: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
57682: WHERE INSTANCE_ID= p_instance_id;
57683:
57684: SELECT MSC_COLLECTION_S.CURRVAL
57685: INTO v_last_collection_id
57686: FROM DUAL;
57687:
57688: RETURN TRUE;