APPS.CHV_BUILD_SCHEDULES dependencies on ECE_OUTPUT_RUNS_S

Line 1077: select 'SPSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),

1073: fnd_profile.get('ECE_OUT_FILE_PATH',x_ece_path);
1074:
1075: IF p_schedule_type = 'PLAN_SCHEDULE' THEN
1076:
1077: select 'SPSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),
1078: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),
1079: 4), 4, '0') || '.dat'
1080: into x_ece_file
1081: from dual;

Line 1078: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),

1074:
1075: IF p_schedule_type = 'PLAN_SCHEDULE' THEN
1076:
1077: select 'SPSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),
1078: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),
1079: 4), 4, '0') || '.dat'
1080: into x_ece_file
1081: from dual;
1082:

Line 1138: select 'SSSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),

1134: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1135:
1136: ELSE
1137:
1138: select 'SSSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),
1139: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),
1140: 4), 4, '0') || '.dat'
1141: into x_ece_file
1142: from dual;

Line 1139: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),

1135:
1136: ELSE
1137:
1138: select 'SSSO' || lpad(substr(to_char(ECE_OUTPUT_RUNS_S.nextval),
1139: decode(length(ECE_OUTPUT_RUNS_S.nextval),1,-1,2, -2,3, -3,-4),
1140: 4), 4, '0') || '.dat'
1141: into x_ece_file
1142: from dual;
1143: