APPS.HXC_GENERIC_RETRIEVAL_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

SELECT	MAX(tbb.object_version_number)
FROM	hxc_time_building_blocks tbb
WHERE	tbb.time_building_block_id	= p_bb_id;

Line: 69

   SELECT htd.time_building_block_id,
          htd.time_building_block_ovn,
          ht.transaction_process_id
     FROM hxc_transaction_details htd,
          hxc_transactions ht,
          hxc_retrieval_processes hrp
    WHERE htd.time_building_block_id = p_curr_bb_id
      AND htd.transaction_id         = ht.transaction_id
      AND ht.type                    = 'RETRIEVAL'
      AND htd.status                 = 'SUCCESS'
      AND ht.transaction_process_id IN (-1,hrp.retrieval_process_id)
      AND hrp.name    =  'BEE Retrieval Process'
      ORDER BY 2 DESC ;

Line: 114

          INSERT INTO hxc_bee_pref_adj_lines
                    ( timecard_id,
                      timecard_ovn,
                      resource_id,
                      detail_bb_id,
                      detail_bb_ovn,
                      date_earned,
                      batch_source
                     )
          VALUES    ( p_tc_id,
                      p_tc_ovn,
                      p_resource_id,
                      l_tbb_id,
                      l_tbb_ovn,
                      p_date_earned,
                      l_batch_source
                     );

Line: 258

	l_period_tab.DELETE;

Line: 360

SELECT
	rrc.time_recipient_id
,	rrc.status
FROM
	hxc_retrieval_rule_comps rrc
,	hxc_retrieval_rules rr
,	hxc_retrieval_rule_grp_comps_v rrgc
,	hxc_retrieval_rule_groups_v rrg
WHERE
	rrg.retrieval_rule_group_id  = p_rtr_grp_id
AND
	rrgc.retrieval_rule_group_id = rrg.retrieval_rule_group_id AND
	rrgc.retrieval_process_id    = p_process_id
AND
	rr.retrieval_rule_id	= rrgc.retrieval_rule_id
AND
	rrc.retrieval_rule_id	= rr.retrieval_rule_id;

Line: 379

SELECT	last_name
FROM	per_people_f
WHERE	person_id = p_resource_id;

Line: 384

SELECT	1
FROM	hxc_application_set_comps_v apsc
,	hxc_application_sets_v aps
WHERE	aps.application_set_id = p_app_set_id
AND
	apsc.application_set_id = aps.application_set_id AND
	apsc.time_recipient_id  = p_ret_tr_id;

Line: 393

SELECT	ret.retrieval_process_id
FROM    hxc_retrieval_processes ret
WHERE   ret.name = 'BEE Retrieval Process';

Line: 457

	--delete the ret ranges table. This is because we maintain ret ranges table for each resource
        l_ret_ranges.delete;

Line: 680

l_tmp_otm_tab.DELETE;

Line: 681

l_tmp_rtr_tab.DELETE;

Line: 733

l_ret_ranges1.delete;

Line: 734

l_ret_ranges_tmp_tab.delete;

Line: 769

l_resource_rtr.DELETE;

Line: 770

l_resource_rrg_id_tab.DELETE;

Line: 794

 l_resource_rrg_id_tab.DELETE(l_rtr_grp_id);

Line: 1121

                ,       p_bb_deleted    VARCHAR2
		,	p_bb_start_time	DATE
		,	p_bb_stop_time	DATE
		,       p_bb_id         NUMBER  -- 6121705
		,       p_bb_ovn        NUMBER  -- 6121705
		,       p_process       VARCHAR2 -- 6121705
		,  	p_prefs		t_pref
		,  	p_ret_rules	t_ret_rule
		,	p_rtr_outcomes	t_rtr_outcome
                ,       p_tc_bb_id      NUMBER
                ,       p_tc_bb_ovn     NUMBER
		,	p_timecard_retrieve IN OUT NOCOPY BOOLEAN
		,	p_day_retrieve	    IN OUT NOCOPY BOOLEAN
                ,       p_tc_locked         IN OUT NOCOPY BOOLEAN
		,       p_tc_first_lock     IN OUT NOCOPY BOOLEAN
		,	p_bb_skipped_reason    OUT NOCOPY VARCHAR2) IS

l_outcome_start	PLS_INTEGER;

Line: 1173

IF ( p_prefs(p_resource_id).prefs_ok = 'Y' AND p_bb_deleted = 'N' )
THEN

	l_rtr_start	:= p_prefs(p_resource_id).rtr_start;

Line: 1193

                 l_rtr_grp.DELETE(p_ret_rules(rtr_cnt).rtr_grp_id);

Line: 1199

		l_rtr_grp.DELETE;

Line: 1211

				l_rtr_grp.DELETE;

Line: 1283

ELSIF ( p_prefs(p_resource_id).prefs_ok = 'Y' AND p_bb_deleted = 'Y' )
THEN

	p_day_retrieve		:= TRUE;

Line: 1544

						l_day_table.DELETE;

Line: 1594

SELECT  transaction_id
,	TRUNC(transaction_date) transaction_date
FROM    hxc_transactions tx
WHERE   tx.transaction_process_id = p_process_id
AND     tx.type = 'RETRIEVAL'
AND     tx.status = 'IN PROGRESS'
AND     tx.transaction_date < p_conc_date
FOR UPDATE OF status NOWAIT;

Line: 1605

SELECT  MIN(cr.actual_start_date)
FROM
	fnd_concurrent_programs cp
,	fnd_concurrent_requests cr
WHERE
	cp.concurrent_program_name = p_conc_program_name AND
	cp.application_id = p_app_id
AND
        cr.concurrent_program_id = cp.concurrent_program_id AND
        cr.status_code = 'R';

Line: 1617

SELECT  a.application_id
FROM    fnd_application a
WHERE   a.application_short_name = p_appl_short_name;

Line: 1780

		-- we have some rogue transactions - let's update them

		l_index := l_tx_tab.FIRST;

Line: 1791

			UPDATE	hxc_transactions tx
			SET	tx.status = 'RECOVERED'
			WHERE   tx.transaction_id = l_index;

Line: 1823

	--       been updated in SQL. 99.9% of the time the transaction will
	--       exist thus the table will be locked

	UPDATE	hxc_retrieval_ranges rr
	SET	rr.transaction_id = -999
	WHERE   rr.creation_date < l_req_date
	AND	rr.retrieval_process_id = p_process_id
	AND	rr.transaction_id = 0;

Line: 1883

SELECT cr.status_code
FROM   fnd_concurrent_requests cr
WHERE  cr.request_id = p_conc_request_id;

Line: 1925

			       select 1
				 from per_all_assignments_f paa, hr_soft_coding_keyflex hsk
				where paa.person_id = rrr.resource_id
				and paa.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
				and hsk.segment1 = :p_gre_id
			  ';

Line: 1933

			       select 1
				 from per_all_assignments_f paa
				where paa.person_id = rrr.resource_id
			  ';