APPS.CHV_BUILD_SCHEDULES dependencies on DUAL

Line 131: FROM dual;

127: SELECT dummy,
128: p_mrp_compile_designator,
129: p_mps_schedule_designator,
130: p_drp_compile_designator
131: FROM dual;
132:
133: -- For all schedules, we will create a new schedule header for each
134: -- vendor, vendor site, bucket pattern, schedule type,
135: -- schedule sub type, and org combination.

Line 548: FROM DUAL;

544: -- Any error will be caught at the exception at the end of the procedure.
545: x_progress := '050';
546: SELECT chv_schedule_headers_s.NEXTVAL
547: INTO x_schedule_id
548: FROM DUAL;
549:
550: ---- dbms_output.put_line('Schedule Header id'||x_schedule_id);
551:
552: ---- dbms_output.put_line('Build_schedule: insert into chv_schedule_headers');

Line 1081: from dual;

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:
1083: select x_ece_path || x_ece_file
1084: into x_ece_path_file
1085: from dual;

Line 1085: from dual;

1081: from dual;
1082:
1083: select x_ece_path || x_ece_file
1084: into x_ece_path_file
1085: from dual;
1086:
1087: /*Bug 1701675:When lauching ECSPSO/ECSSSO transactions,a extra parameter called
1088: x_ece_path_file is passed to ECSPSO/ECSSSO concurrent program.
1089: This parameter is not in ECSPSO/ECSSSO concurrent program.Hence

Line 1142: from dual;

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:
1144: select x_ece_path || x_ece_file
1145: into x_ece_path_file
1146: from dual;

Line 1146: from dual;

1142: from dual;
1143:
1144: select x_ece_path || x_ece_file
1145: into x_ece_path_file
1146: from dual;
1147:
1148: /* Bug 2090899: Passing Batch Id also as one of the parameter as requested
1149: by EDI Team.
1150: */

Line 1250: FROM DUAL;

1246: x_progress := '010';
1247:
1248: SELECT chv_schedule_headers_s2.NEXTVAL
1249: INTO x_count_l
1250: FROM DUAL;
1251:
1252: x_schedule_num := TO_CHAR(SYSDATE, 'YYYYMMDD') || '-' ||
1253: TO_CHAR(x_count_l);
1254: x_schedule_revision := 0;

Line 1499: FROM sys.dual;

1495: -- We must open a cursor if this is not multi-org. This is a dummy
1496: -- cursor that will find one record.
1497: CURSOR C_ITEM_NOORGS IS
1498: SELECT dummy
1499: FROM sys.dual;
1500:
1501: -- Get all orgs currently on the schedule
1502: CURSOR C_ITEM_ORGS_REVISION IS
1503: SELECT distinct csi.organization_id

Line 1868: FROM DUAL;

1864: IF p_schedule_category <> 'REBUILD' THEN
1865: x_progress := '060';
1866: SELECT chv_schedule_items_s.NEXTVAL
1867: INTO x_schedule_item_id_l
1868: FROM DUAL;
1869:
1870: ---- dbms_output.put_line ('Create_items: inserting into chv_schedule_items');
1871: ---- dbms_output.put_line ('Create_items: schedule id'||x_schedule_id);
1872: ---- dbms_output.put_line ('Create_items: schedule_item_id'||x_schedule_item_id_l);