DBA Data[Home] [Help]

APPS.CZ_UPGRADE dependencies on CZ_XFR_RUN_INFOS_S

Line 1012: SELECT cz_xfr_run_infos_s.nextval into v_run_id FROM dual;

1008: v_run_id cz_db_logs.run_id%TYPE;
1009: v_caller cz_db_logs.caller%TYPE;
1010:
1011: BEGIN
1012: SELECT cz_xfr_run_infos_s.nextval into v_run_id FROM dual;
1013:
1014: v_message := 'Logic upgrade from schema '||p_from_schema||' for lce_header_id '||p_lce_header_id||' : '||p_err_message ;
1015: v_message := SUBSTR(v_message,1,2000);
1016:

Line 2998: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;

2994: --Get the logic generation run id. If a valid value has been passed as a parameter, use it,
2995: --else generate a new value.
2996:
2997: IF(thisRunId IS NULL OR thisRunId = 0)THEN
2998: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;
2999: END IF;
3000:
3001: globalLevel := globalLevel + 1;
3002: globalStack(globalLevel) := inDevlProjectId;