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.HXC_DATA_SET dependencies on HXC_DATA_SET

Line 1: PACKAGE BODY hxc_data_set AS

1: PACKAGE BODY hxc_data_set AS
2: /* $Header: hxcdataset.pkb 120.8.12020000.2 2012/07/04 09:18:20 amnaraya ship $ */
3:
4: ----------------------------------------------------------------------------
5: -- Function Name : validate_data_set_range

Line 23: FROM hxc_data_sets

19:
20: CURSOR c_check_range_exists(p_start_date date, p_end_date date)
21: IS
22: SELECT 1
23: FROM hxc_data_sets
24: WHERE start_date < p_end_date
25: AND end_date > p_start_date;
26:
27: CURSOR c_check_name_exists(p_data_set_name varchar2)

Line 30: FROM hxc_data_sets

26:
27: CURSOR c_check_name_exists(p_data_set_name varchar2)
28: IS
29: SELECT 1
30: FROM hxc_data_sets
31: WHERE data_set_name = p_data_set_name;
32:
33:
34: l_dummy pls_integer;

Line 89: from hxc_data_sets

85: cursor c_data_sets is
86: select DATA_SET_ID,DATA_SET_NAME,DESCRIPTION,START_DATE,END_DATE,DATA_SET_MODE,
87: decode(STATUS,'BACKUP_IN_PROGRESS','ARCHIVE_IN_PROGRESS',STATUS) status,
88: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,VALIDATION_STATUS
89: from hxc_data_sets
90: where status <> 'MARKING_IN_PROGRESS';
91:
92:
93: BEGIN

Line 123: --Description : This procedure inserts the record into hxc_data_sets table corresponding to new

119:
120:
121: --------------------------------------------------------------------------------------------------
122: --Procedure Name : insert_into_data_set
123: --Description : This procedure inserts the record into hxc_data_sets table corresponding to new
124: -- Data set.
125: --------------------------------------------------------------------------------------------------
126:
127: PROCEDURE insert_into_data_set(p_data_set_id OUT NOCOPY NUMBER,

Line 136: --get the sequence from hxc_data_sets_s

132: p_status IN VARCHAR2) is
133:
134: BEGIN
135:
136: --get the sequence from hxc_data_sets_s
137: select hxc_data_sets_s.nextval into p_data_set_id from dual;
138:
139: insert into hxc_data_sets
140: (data_set_id,

Line 137: select hxc_data_sets_s.nextval into p_data_set_id from dual;

133:
134: BEGIN
135:
136: --get the sequence from hxc_data_sets_s
137: select hxc_data_sets_s.nextval into p_data_set_id from dual;
138:
139: insert into hxc_data_sets
140: (data_set_id,
141: data_set_name,

Line 139: insert into hxc_data_sets

135:
136: --get the sequence from hxc_data_sets_s
137: select hxc_data_sets_s.nextval into p_data_set_id from dual;
138:
139: insert into hxc_data_sets
140: (data_set_id,
141: data_set_name,
142: description,
143: start_date,

Line 382: FROM hxc_data_sets

378:
379: CURSOR c_get_data_set_status is
380: SELECT data_set_name, description, start_date, end_date,
381: data_set_mode, status, validation_status
382: FROM hxc_data_sets
383: WHERE data_set_id = p_data_set_id;
384:
385: BEGIN
386:

Line 494: DELETE FROM hxc_data_sets

490: undo_define_table(p_table_name => 'HXC_TIMECARD_SUMMARY',
491: p_data_set_id => p_data_set_id,
492: p_chunk_size => l_chunk_size);
493:
494: DELETE FROM hxc_data_sets
495: WHERE data_set_id = p_data_set_id;
496:
497: COMMIT;
498:

Line 533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks

529: -- is no point in stopping it from getting archived.
530:
531: -- Bug 14028697
532: -- Modified the below cursor to have a better access path.
533: -- hxc_data_sets -> hxc_timecard_summary -> hxc_time_building_blocks
534: --
535:
536: /*
537:

Line 552: hxc_data_sets hds,

548: FROM
549: hxc_time_building_blocks day,
550: hxc_time_building_blocks det,
551: hxc_latest_details hld,
552: hxc_data_sets hds,
553: hxc_timecard_summary tsum,
554: hxc_application_sets_v has,
555: hxc_application_set_comps_v hasv,
556: per_all_people_f per

Line 616: SELECT/*+ INDEX(hds HXC_DATA_SETS_PK)

612: */
613:
614: CURSOR c_get_unretrieved_tcs(p_data_set_id number,l_bee_retrieval number)
615: IS
616: SELECT/*+ INDEX(hds HXC_DATA_SETS_PK)
617: INDEX(tsum HXC_TIMECARD_SUMMARY_N1)
618: INDEX(day HXC_TIME_BUILDING_BLOCKS_FK3)
619: INDEX(det HXC_TIME_BUILDING_BLOCKS_FK3)
620: INDEX(per PER_PEOPLE_F_PK) */

Line 628: FROM hxc_data_sets hds,

624: tsum.stop_time,
625: tsum.approval_status,
626: nvl(per.employee_number,'Employee Number Unkown') employee_number,
627: nvl(per.full_name,'Full Name Unknown') full_name
628: FROM hxc_data_sets hds,
629: hxc_timecard_summary tsum,
630: hxc_time_building_blocks day,
631: hxc_time_building_blocks det,
632: hxc_latest_details hld,

Line 708: hxc_data_sets d,

704: tsum.stop_time,
705: nvl(per.employee_number,'Employee Number Unkown') employee_number,
706: nvl(per.full_name,'Full Name Unknown') full_name
707: FROM hxc_timecard_summary tsum,
708: hxc_data_sets d,
709: per_all_people_f per
710: WHERE tsum.approval_status ='ERROR'
711: AND per.person_id = tsum.resource_id
712: AND sysdate between per.effective_start_date and per.effective_end_date

Line 1024: UPDATE hxc_data_sets

1020: END If;
1021:
1022:
1023: --finally set the validation status
1024: UPDATE hxc_data_sets
1025: SET validation_status = l_validation_status
1026: WHERE data_set_id = p_data_set_id;
1027:
1028:

Line 1123: END hxc_data_set;

1119: );
1120:
1121: END release_lock_data_set;
1122:
1123: END hxc_data_set;