APPS.PER_CEI_SHD dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 44: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE)

40: --
41: -- ---------------------------------------------------------------------------
42: --
43: FUNCTION entitlement_item_in_use
44: (p_cagr_entitlement_item_id IN per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE)
45: RETURN BOOLEAN IS
46: --
47: CURSOR csr_get_entitlements IS
48: SELECT pce.cagr_entitlement_item_id

Line 53: l_dummy_item per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;

49: FROM per_cagr_entitlements pce
50: WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
51: --
52: l_return_value BOOLEAN;
53: l_dummy_item per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE;
54: l_proc VARCHAR2(72) := g_package||'entitlement_item_in_use';
55: --
56: BEGIN
57: --

Line 106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then

102: l_proc varchar2(72) := g_package||'constraint_error';
103: --
104: Begin
105: --
106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then
107: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;

Line 153: from per_cagr_entitlement_items

149: ,beneficial_rule_value_set_id
150: ,multiple_entries_allowed_flag
151: ,auto_create_entries_flag -- CEI Enh
152: ,opt_id
153: from per_cagr_entitlement_items
154: where cagr_entitlement_item_id = p_cagr_entitlement_item_id;
155: --
156: l_fct_ret boolean;
157: --

Line 231: from per_cagr_entitlement_items

227: ,beneficial_rule_value_set_id
228: ,multiple_entries_allowed_flag
229: ,auto_create_entries_flag -- CEI Enh
230: ,opt_id
231: from per_cagr_entitlement_items
232: where cagr_entitlement_item_id = p_cagr_entitlement_item_id
233: for update nowait;
234: --
235: l_proc varchar2(72) := g_package||'lck';

Line 275: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items');

271: -- The object is locked therefore we need to supply a meaningful
272: -- error message.
273: --
274: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
275: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items');
276: fnd_message.raise_error;
277: End lck;
278: --
279: -- ----------------------------------------------------------------------------