eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_ADMIN_PVT dependencies on IEC_G_CAL_CALLABLE_RGNS

Line 1459: select CALLABLE_REGION_CODE, START_TIME, END_TIME, TYPE_CODE from iec_g_cal_callable_rgns

1455: )
1456: AS
1457: l_day_copyto_id NUMBER;
1458: cursor c_copy is
1459: select CALLABLE_REGION_CODE, START_TIME, END_TIME, TYPE_CODE from iec_g_cal_callable_rgns
1460: where DAY_ID = p_day_id;
1461: BEGIN
1462: select day_id into l_day_copyto_id from iec_g_cal_days_b where CALENDAR_ID = p_calendar_id
1463: and DAY_CODE = 'DAY_OF_WEEK' and PATTERN_CODE = p_copyto_code;

Line 1465: delete from iec_g_cal_callable_rgns where DAY_ID = l_day_copyto_id;

1461: BEGIN
1462: select day_id into l_day_copyto_id from iec_g_cal_days_b where CALENDAR_ID = p_calendar_id
1463: and DAY_CODE = 'DAY_OF_WEEK' and PATTERN_CODE = p_copyto_code;
1464:
1465: delete from iec_g_cal_callable_rgns where DAY_ID = l_day_copyto_id;
1466: for v_copy in c_copy loop
1467: insert into iec_g_cal_callable_rgns(CALLABLE_REGION_ID, DAY_ID, CALLABLE_REGION_CODE,
1468: START_TIME, END_TIME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
1469: OBJECT_VERSION_NUMBER, TYPE_CODE)

Line 1467: insert into iec_g_cal_callable_rgns(CALLABLE_REGION_ID, DAY_ID, CALLABLE_REGION_CODE,

1463: and DAY_CODE = 'DAY_OF_WEEK' and PATTERN_CODE = p_copyto_code;
1464:
1465: delete from iec_g_cal_callable_rgns where DAY_ID = l_day_copyto_id;
1466: for v_copy in c_copy loop
1467: insert into iec_g_cal_callable_rgns(CALLABLE_REGION_ID, DAY_ID, CALLABLE_REGION_CODE,
1468: START_TIME, END_TIME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
1469: OBJECT_VERSION_NUMBER, TYPE_CODE)
1470: values (IEC_G_CAL_CALLABLE_RGNS_S.NEXTVAL,l_day_copyto_id,v_copy.CALLABLE_REGION_CODE,
1471: v_copy.START_TIME, v_copy.END_TIME,p_createdBy, p_creationDate,p_updatedBy,p_updateDate,

Line 1470: values (IEC_G_CAL_CALLABLE_RGNS_S.NEXTVAL,l_day_copyto_id,v_copy.CALLABLE_REGION_CODE,

1466: for v_copy in c_copy loop
1467: insert into iec_g_cal_callable_rgns(CALLABLE_REGION_ID, DAY_ID, CALLABLE_REGION_CODE,
1468: START_TIME, END_TIME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
1469: OBJECT_VERSION_NUMBER, TYPE_CODE)
1470: values (IEC_G_CAL_CALLABLE_RGNS_S.NEXTVAL,l_day_copyto_id,v_copy.CALLABLE_REGION_CODE,
1471: v_copy.START_TIME, v_copy.END_TIME,p_createdBy, p_creationDate,p_updatedBy,p_updateDate,
1472: p_updateLogin, p_versionNumber,v_copy.TYPE_CODE);
1473: end loop;
1474: commit;