DBA Data[Home] [Help]

APPS.PER_CEI_INS dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 58: l_created_by per_cagr_entitlement_items.created_by%TYPE;

54: (p_rec in out nocopy per_cei_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;
60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;
61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;
62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;

Line 59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;
60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;
61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;
62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;
63: --

Line 60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;
60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;
61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;
62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;
63: --
64: Begin

Line 61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;
60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;
61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;
62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;
63: --
64: Begin
65: --

Line 62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;

58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
59: l_creation_date per_cagr_entitlement_items.creation_date%TYPE;
60: l_last_update_date per_cagr_entitlement_items.last_update_date%TYPE;
61: l_last_updated_by per_cagr_entitlement_items.last_updated_by%TYPE;
62: l_last_update_login per_cagr_entitlement_items.last_update_login%TYPE;
63: --
64: Begin
65: --
66: hr_utility.set_location('Entering:'||l_proc, 5);

Line 78: -- Insert the row into: per_cagr_entitlement_items

74: l_last_update_date := sysdate;
75: l_last_updated_by := fnd_global.user_id;
76: l_last_update_login := fnd_global.login_id;
77: --
78: -- Insert the row into: per_cagr_entitlement_items
79: --
80: insert into per_cagr_entitlement_items
81: (cagr_entitlement_item_id
82: ,item_name

Line 80: insert into per_cagr_entitlement_items

76: l_last_update_login := fnd_global.login_id;
77: --
78: -- Insert the row into: per_cagr_entitlement_items
79: --
80: insert into per_cagr_entitlement_items
81: (cagr_entitlement_item_id
82: ,item_name
83: ,element_type_id
84: ,input_value_id

Line 202: Cursor C_Sel1 is select per_cagr_entitlement_items_s.nextval from sys.dual;

198: ) is
199: --
200: l_proc varchar2(72) := g_package||'pre_insert';
201: --
202: Cursor C_Sel1 is select per_cagr_entitlement_items_s.nextval from sys.dual;
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --

Line 292: (p_module_name => 'PER_CAGR_ENTITLEMENT_ITEMS'

288: --
289: when hr_api.cannot_find_prog_unit then
290: --
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'PER_CAGR_ENTITLEMENT_ITEMS'
293: ,p_hook_type => 'AI');
294: --
295: end;
296: --