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.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_WEEKLY_WORK_SCHEDULES

Line 38: FROM hxt_weekly_work_schedules wws;

34: CURSOR c_get_workplans IS
35: SELECT DISTINCT
36: wws.id
37: , wws.name
38: FROM hxt_weekly_work_schedules wws;
39: --
40: -- cursor to get all rotation plans.
41: --
42: CURSOR c_get_rotation_plans IS

Line 175: FROM hxt_weekly_work_schedules

171: AND ws.off_shift_prem_id = pet.element_type_id
172: AND pet.business_group_id is not null
173: UNION
174: SELECT business_group_id
175: FROM hxt_weekly_work_schedules
176: WHERE id = p_wp_id
177: AND business_group_id is not null;
178: --
179: l_count number := 0;

Line 212: , hxt_weekly_work_schedules wws

208: --
209: CURSOR c_rp_bg_check is
210: select distinct(pet.business_group_id) bg
211: from hxt_rotation_schedules rts
212: , hxt_weekly_work_schedules wws
213: , hxt_work_shifts wsh
214: , pay_element_types_f pet
215: where wws.id = rts.tws_id
216: and rts.rtp_id = p_rp_id

Line 223: , hxt_weekly_work_schedules wws

219: and pet.business_group_id is not null
220: union
221: select distinct(pet.business_group_id) bg
222: from hxt_rotation_schedules rts
223: , hxt_weekly_work_schedules wws
224: , hxt_work_shifts wsh
225: , pay_element_types_f pet
226: where wws.id = rts.tws_id
227: and rts.rtp_id = p_rp_id

Line 234: from hxt_weekly_work_schedules wws

230: and pet.business_group_id is not null
231: union
232: select distinct
233: wws.business_group_id
234: from hxt_weekly_work_schedules wws
235: , hxt_rotation_schedules rts
236: where wws.id = rts.tws_id
237: and rts.rtp_id = p_rp_id
238: and wws.business_group_id is not null;

Line 947: from hxt_weekly_work_schedules wws

943: CURSOR c_bg_workplans IS
944: select distinct
945: wsh.tws_id id
946: , pet.business_group_id bg
947: from hxt_weekly_work_schedules wws
948: , hxt_work_shifts wsh
949: , pay_element_types_f pet
950: where wws.business_group_id is null
951: and wws.id = wsh.tws_id

Line 962: from hxt_weekly_work_schedules wws

958: select distinct
959: wws.id wp_id
960: , rp_sub.rp_count rp_cnt
961: , ass_sub.ass_count ass_cnt
962: from hxt_weekly_work_schedules wws
963: , (select tws_id wp_id
964: , count(rtp_id) rp_count
965: from hxt_rotation_schedules
966: group by tws_id) rp_sub

Line 992: , hxt_weekly_work_schedules wws

988: --
989: CURSOR c_get_rp_bg(p_wp_id number) is
990: select distinct(pet.business_group_id) rp_bg
991: from hxt_rotation_schedules rts
992: , hxt_weekly_work_schedules wws
993: , hxt_work_shifts wsh
994: , pay_element_types_f pet
995: where rts.tws_id = wws.id
996: and wws.id = wsh.tws_id

Line 1007: , hxt_weekly_work_schedules wws

1003: where sub.tws_id = p_wp_id)
1004: union
1005: select distinct(wws.business_group_id) rp_bg
1006: from hxt_rotation_schedules rts
1007: , hxt_weekly_work_schedules wws
1008: where rts.tws_id = wws.id
1009: and wws.business_group_id is not null
1010: and rts.rtp_id IN (select sub.rtp_id
1011: from hxt_rotation_schedules sub

Line 1039: UPDATE hxt_weekly_work_schedules

1035: Begin
1036: l_wp_id := p_wp_id;
1037: l_bg_id := p_bg_id;
1038: --
1039: UPDATE hxt_weekly_work_schedules
1040: SET business_group_id = l_bg_id
1041: WHERE id = l_wp_id;
1042: --
1043: hxt_bg_message_insert('U','Updating Workplan ID '||l_wp_id||' With Business Group '||l_bg_id);

Line 1116: from hxt_weekly_work_schedules

1112: , start_day
1113: , date_from
1114: , description
1115: , date_to
1116: from hxt_weekly_work_schedules
1117: where id = p_wp_id;
1118: --
1119: CURSOR c_workshift_rec is
1120: select sht_id

Line 1144: Insert Into hxt_weekly_work_schedules

1140: open c_seqno;
1141: fetch c_seqno into l_id;
1142: close c_seqno;
1143: --
1144: Insert Into hxt_weekly_work_schedules
1145: ( id
1146: , name
1147: , start_day
1148: , date_from

Line 1213: delete from hxt_weekly_work_schedules

1209: --
1210: delete from hxt_work_shifts
1211: where tws_id = p_wp_id;
1212: --
1213: delete from hxt_weekly_work_schedules
1214: where id = p_wp_id;
1215: --
1216: End duplicate_workplans;
1217: --

Line 1252: from hxt_weekly_work_schedules wws

1248: , wws.start_day
1249: , wws.date_from
1250: , wws.description
1251: , wws.date_to
1252: from hxt_weekly_work_schedules wws
1253: , hxt_rotation_schedules rts
1254: where wws.id = rts.tws_id
1255: and rts.rtp_id = p_rp_id;
1256: --

Line 1289: from hxt_weekly_work_schedules

1285: and rtp_id = p_rp_id;
1286: --
1287: CURSOR c_dup_check(p_bg_id number, p_name varchar2) is
1288: select id
1289: from hxt_weekly_work_schedules
1290: where business_group_id = p_bg_id
1291: and name = p_name;
1292: --
1293: Begin

Line 1343: Insert Into hxt_weekly_work_schedules

1339: open c_seqno;
1340: fetch c_seqno into l_wp_id;
1341: close c_seqno;
1342: --
1343: Insert Into hxt_weekly_work_schedules
1344: ( id
1345: , name
1346: , start_day
1347: , date_from

Line 1459: delete from hxt_weekly_work_schedules

1455: --
1456: delete from hxt_work_shifts
1457: where tws_id = p_wp_id;
1458: --
1459: delete from hxt_weekly_work_schedules
1460: where id = p_wp_id;
1461: --
1462: End duplicate_rotation_plans;
1463: --