APPS.HXC_DATA_SET dependencies on HXC_DATA_SETS

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 546: hxc_data_sets hds,

542: FROM
543: hxc_time_building_blocks day,
544: hxc_time_building_blocks det,
545: hxc_latest_details hld,
546: hxc_data_sets hds,
547: hxc_timecard_summary tsum,
548: hxc_application_sets_v has,
549: hxc_application_set_comps_v hasv,
550: per_all_people_f per

Line 619: hxc_data_sets d,

615: tsum.stop_time,
616: nvl(per.employee_number,'Employee Number Unkown') employee_number,
617: nvl(per.full_name,'Full Name Unknown') full_name
618: FROM hxc_timecard_summary tsum,
619: hxc_data_sets d,
620: per_all_people_f per
621: WHERE tsum.approval_status ='ERROR'
622: AND per.person_id = tsum.resource_id
623: AND sysdate between per.effective_start_date and per.effective_end_date

Line 935: UPDATE hxc_data_sets

931: END If;
932:
933:
934: --finally set the validation status
935: UPDATE hxc_data_sets
936: SET validation_status = l_validation_status
937: WHERE data_set_id = p_data_set_id;
938:
939: