APPS.PER_CAI_BUS dependencies on PER_CAGR_APIS

Line 27: -- per_cagr_apis and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- per_cagr_apis and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is

Line 34: , per_cagr_apis cai

30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_cagr_apis cai
35: -- , EDIT_HERE table_name(s) 333
36: where cai.cagr_api_id = p_cagr_api_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 93: -- per_cagr_apis and PER_BUSINESS_GROUPS

89: --
90: -- Declare cursor
91: --
92: -- EDIT_HERE In the following cursor statement add join(s) between
93: -- per_cagr_apis and PER_BUSINESS_GROUPS
94: -- so that the legislation_code for
95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is

Line 100: , per_cagr_apis cai

96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , per_cagr_apis cai
101: -- , EDIT_HERE table_name(s) 333
102: where cai.cagr_api_id = p_cagr_api_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
104: --

Line 191: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE

187: --
188: -- ---------------------------------------------------------------------------
189: --
190: PROCEDURE chk_api_name
191: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE
192: ,p_api_name IN per_cagr_apis.api_name%TYPE) is
193: --
194: l_proc VARCHAR2(72) := g_package||'chk_api_name';
195: l_dummy per_cagr_apis.api_name%TYPE;

Line 192: ,p_api_name IN per_cagr_apis.api_name%TYPE) is

188: -- ---------------------------------------------------------------------------
189: --
190: PROCEDURE chk_api_name
191: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE
192: ,p_api_name IN per_cagr_apis.api_name%TYPE) is
193: --
194: l_proc VARCHAR2(72) := g_package||'chk_api_name';
195: l_dummy per_cagr_apis.api_name%TYPE;
196: --

Line 195: l_dummy per_cagr_apis.api_name%TYPE;

191: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE
192: ,p_api_name IN per_cagr_apis.api_name%TYPE) is
193: --
194: l_proc VARCHAR2(72) := g_package||'chk_api_name';
195: l_dummy per_cagr_apis.api_name%TYPE;
196: --
197: CURSOR csr_api_name IS
198: SELECT null
199: FROM per_cagr_apis per

Line 199: FROM per_cagr_apis per

195: l_dummy per_cagr_apis.api_name%TYPE;
196: --
197: CURSOR csr_api_name IS
198: SELECT null
199: FROM per_cagr_apis per
200: WHERE ((per.cagr_api_id <> p_cagr_api_id) OR
201: (p_cagr_api_id IS NULL))
202: AND per.api_name = p_api_name;
203: --

Line 291: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE

287: --
288: -- ---------------------------------------------------------------------------
289: --
290: PROCEDURE chk_category_name
291: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE
292: ,p_category_name IN per_cagr_apis.category_name%TYPE
293: ,p_effective_date IN DATE) IS
294: --
295: l_proc VARCHAR2(72) := g_package||'chk_category_name';

Line 292: ,p_category_name IN per_cagr_apis.category_name%TYPE

288: -- ---------------------------------------------------------------------------
289: --
290: PROCEDURE chk_category_name
291: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE
292: ,p_category_name IN per_cagr_apis.category_name%TYPE
293: ,p_effective_date IN DATE) IS
294: --
295: l_proc VARCHAR2(72) := g_package||'chk_category_name';
296: --

Line 369: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE) IS

365: --
366: -- ---------------------------------------------------------------------------
367: --
368: PROCEDURE chk_api_use
369: (p_cagr_api_id IN per_cagr_apis.cagr_api_id%TYPE) IS
370: --
371: l_proc varchar2(72) := g_package || 'chk_api_use';
372: l_dummy per_cagr_entitlement_items.item_name%TYPE;
373: --