APPS.HR_TEMPLATE_DATA_GROUPS_PKG dependencies on HR_TEMPLATE_DATA_GROUPS

Line 1: package body HR_TEMPLATE_DATA_GROUPS_PKG as

1: package body HR_TEMPLATE_DATA_GROUPS_PKG as
2: /* $Header: hrtdglct.pkb 120.1 2011/04/28 10:59:42 sidsaxen ship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out nocopy DATE,

Line 35: cursor C is select ROWID from HR_TEMPLATE_DATA_GROUPS

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from HR_TEMPLATE_DATA_GROUPS
36: where TEMPLATE_DATA_GROUP_ID = X_TEMPLATE_DATA_GROUP_ID
37: ;
38: begin
39:

Line 47: p_entity_name => 'HR_TEMPLATE_DATA_GROUPS',

43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_DATA_GROUPS',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_B', PER_RIC_PKG.column_info_tbl(

Line 60: insert into HR_TEMPLATE_DATA_GROUPS (

56: END;
57: --
58: -- Code Ends Here.
59: --
60: insert into HR_TEMPLATE_DATA_GROUPS (
61: TEMPLATE_DATA_GROUP_ID,
62: OBJECT_VERSION_NUMBER,
63: FORM_TEMPLATE_ID,
64: FORM_DATA_GROUP_ID,

Line 101: from HR_TEMPLATE_DATA_GROUPS

97: cursor c1 is select
98: OBJECT_VERSION_NUMBER,
99: FORM_TEMPLATE_ID,
100: FORM_DATA_GROUP_ID
101: from HR_TEMPLATE_DATA_GROUPS
102: where TEMPLATE_DATA_GROUP_ID = X_TEMPLATE_DATA_GROUP_ID
103: for update of TEMPLATE_DATA_GROUP_ID nowait;
104: begin
105: for tlinfo in c1 loop

Line 129: update HR_TEMPLATE_DATA_GROUPS set

125: X_LAST_UPDATED_BY in NUMBER,
126: X_LAST_UPDATE_LOGIN in NUMBER
127: ) is
128: begin
129: update HR_TEMPLATE_DATA_GROUPS set
130: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
131: FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID,
132: FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID,
133: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 147: delete from HR_TEMPLATE_DATA_GROUPS

143: procedure DELETE_ROW (
144: X_TEMPLATE_DATA_GROUP_ID in NUMBER
145: ) is
146: begin
147: delete from HR_TEMPLATE_DATA_GROUPS
148: where TEMPLATE_DATA_GROUP_ID = X_TEMPLATE_DATA_GROUP_ID;
149:
150: if (sql%notfound) then
151: raise no_data_found;

Line 216: from hr_template_data_groups

212:
213: begin
214: select template_data_group_id
215: into x_template_data_group_id
216: from hr_template_data_groups
217: where form_template_id = x_form_template_id
218: and form_data_group_id = x_form_data_group_id;
219: exception
220: when no_data_found then

Line 221: select hr_template_data_groups_s.nextval

217: where form_template_id = x_form_template_id
218: and form_data_group_id = x_form_data_group_id;
219: exception
220: when no_data_found then
221: select hr_template_data_groups_s.nextval
222: into x_template_data_group_id
223: from dual;
224: end;
225:

Line 251: end HR_TEMPLATE_DATA_GROUPS_PKG;

247: X_LAST_UPDATED_BY,
248: X_LAST_UPDATE_LOGIN );
249: end;
250: end LOAD_ROW;
251: end HR_TEMPLATE_DATA_GROUPS_PKG;