APPS.HXC_RETRIEVAL_RULE_COMPS_API dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 1: Package Body hxc_retrieval_rule_comps_api as

1: Package Body hxc_retrieval_rule_comps_api as
2: /* $Header: hxcrtcapi.pkb 120.2 2005/09/23 06:21:33 nissharm noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hxc_retrieval_rule_comps_api.';

2: /* $Header: hxcrtcapi.pkb 120.2 2005/09/23 06:21:33 nissharm noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_retrieval_rule_comps_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------

Line 28: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE;

24: -- Declare cursors and local variables
25: --
26:
27: l_proc varchar2(72);
28: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE;
29: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;
30: --
31: Begin
32: g_debug := hr_utility.debug_enabled;

Line 29: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;

25: --
26:
27: l_proc varchar2(72);
28: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE;
29: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;
30: --
31: Begin
32: g_debug := hr_utility.debug_enabled;
33: --

Line 54: hxc_retrieval_rule_comps_bk_1.create_retrieval_rule_comps_b

50: --
51: -- Call Before Process User Hook
52: --
53: begin
54: hxc_retrieval_rule_comps_bk_1.create_retrieval_rule_comps_b
55: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
56: ,p_object_version_number => p_object_version_number
57: ,p_retrieval_rule_id => p_retrieval_rule_id
58: ,p_status => p_status

Line 106: hxc_retrieval_rule_comps_bk_1.create_retrieval_rule_comps_a

102: --
103: -- Call After Process User Hook
104: --
105: begin
106: hxc_retrieval_rule_comps_bk_1.create_retrieval_rule_comps_a
107: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
108: ,p_object_version_number => p_object_version_number
109: ,p_retrieval_rule_id => p_retrieval_rule_id
110: ,p_status => p_status

Line 193: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE := p_object_version_number;

189: --
190: -- Declare cursors and local variables
191: --
192: l_proc varchar2(72);
193: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE := p_object_version_number;
194: --
195: Begin
196: g_debug := hr_utility.debug_enabled;
197: --

Line 214: hxc_retrieval_rule_comps_bk_1.update_retrieval_rule_comps_b

210: --
211: -- Call Before Process User Hook
212: --
213: begin
214: hxc_retrieval_rule_comps_bk_1.update_retrieval_rule_comps_b
215: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
216: ,p_object_version_number => p_object_version_number
217: ,p_retrieval_rule_id => p_retrieval_rule_id
218: ,p_status => p_status

Line 254: hxc_retrieval_rule_comps_bk_1.update_retrieval_rule_comps_a

250: --
251: -- Call After Process User Hook
252: --
253: begin
254: hxc_retrieval_rule_comps_bk_1.update_retrieval_rule_comps_a
255: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
256: ,p_object_version_number => p_object_version_number
257: ,p_retrieval_rule_id => p_retrieval_rule_id
258: ,p_status => p_status

Line 354: hxc_retrieval_rule_comps_bk_1.delete_retrieval_rule_comps_b

350: -- Call Before Process User Hook
351: --
352: begin
353: --
354: hxc_retrieval_rule_comps_bk_1.delete_retrieval_rule_comps_b
355: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
356: ,p_object_version_number => p_object_version_number
357: );
358: exception

Line 386: hxc_retrieval_rule_comps_bk_1.delete_retrieval_rule_comps_a

382: -- Call After Process User Hook
383: --
384: begin
385: --
386: hxc_retrieval_rule_comps_bk_1.delete_retrieval_rule_comps_a
387: (p_retrieval_rule_comp_id => p_retrieval_rule_comp_id
388: ,p_object_version_number => p_object_version_number
389: );
390: exception

Line 468: from hxc_retrieval_rule_comps rc, hxc_retrieval_rules rr

464: FROM sys.dual
465: WHERE EXISTS (select a
466: from (
467: select rc.retrieval_rule_id a,count(*) CNT
468: from hxc_retrieval_rule_comps rc, hxc_retrieval_rules rr
469: where rr.RETRIEVAL_PROCESS_ID = (select RETRIEVAL_PROCESS_ID
470: from hxc_retrieval_rules
471: where retrieval_rule_id=p_retrieval_rule_id)
472: and rr.retrieval_rule_id <> p_retrieval_rule_id

Line 476: from hxc_retrieval_rule_comps

472: and rr.retrieval_rule_id <> p_retrieval_rule_id
473: and rc.retrieval_rule_id <> p_retrieval_rule_id
474: and rc.retrieval_rule_id = rr.retrieval_rule_id
475: and (rc.TIME_RECIPIENT_ID, rc.STATUS) in ( select TIME_RECIPIENT_ID, STATUS
476: from hxc_retrieval_rule_comps
477: where retrieval_rule_id = p_retrieval_rule_id
478: )
479: group by rc.retrieval_rule_id
480:

Line 483: from hxc_retrieval_rule_comps

479: group by rc.retrieval_rule_id
480:
481: )
482: where CNT = (select count(distinct time_recipient_id)
483: from hxc_retrieval_rule_comps
484: where retrieval_rule_id = p_retrieval_rule_id)
485: and a not in (
486: select retrieval_rule_id
487: from hxc_retrieval_rule_comps

Line 487: from hxc_retrieval_rule_comps

483: from hxc_retrieval_rule_comps
484: where retrieval_rule_id = p_retrieval_rule_id)
485: and a not in (
486: select retrieval_rule_id
487: from hxc_retrieval_rule_comps
488: where
489: (TIME_RECIPIENT_ID, STATUS) not in ( select TIME_RECIPIENT_ID, STATUS
490: from hxc_retrieval_rule_comps
491: where retrieval_rule_id = p_retrieval_rule_id

Line 490: from hxc_retrieval_rule_comps

486: select retrieval_rule_id
487: from hxc_retrieval_rule_comps
488: where
489: (TIME_RECIPIENT_ID, STATUS) not in ( select TIME_RECIPIENT_ID, STATUS
490: from hxc_retrieval_rule_comps
491: where retrieval_rule_id = p_retrieval_rule_id
492: )
493: ));
494:

Line 526: end hxc_retrieval_rule_comps_api;

522: --
523: END chk_retr_as_unique;
524: --
525: --
526: end hxc_retrieval_rule_comps_api;