APPS.HR_ORG_INFO_TYPES_BY_CLASS_PKG dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 1: package body HR_ORG_INFO_TYPES_BY_CLASS_PKG as

1: package body HR_ORG_INFO_TYPES_BY_CLASS_PKG as
2: /* $Header: hroiclct.pkb 120.5 2011/04/28 18:38:21 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_ORG_INFO_TYPES_BY_CLASS

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_ORG_INFO_TYPES_BY_CLASS
36: where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
37: and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
38: ;
39: begin

Line 46: p_entity_name=>'HR_ORG_INFO_TYPES_BY_CLASS',

42: -- Added the following code as a part of Zero Downtime Patching Project.
43: -- Code Starts Here.
44: --
45: per_ric_pkg.Chk_integrity(
46: p_entity_name=>'HR_ORG_INFO_TYPES_BY_CLASS',
47: p_ref_entity=>'HR_ORG_INFORMATION_TYPES',
48: p_ref_column_name=>'ORG_INFORMATION_TYPE',
49: p_ref_col_value_varchar=> X_ORG_INFORMATION_TYPE,
50: p_ref_col_value_number=> NULL,

Line 57: insert into HR_ORG_INFO_TYPES_BY_CLASS (

53: --
54: -- Code Ends Here
55: --
56:
57: insert into HR_ORG_INFO_TYPES_BY_CLASS (
58: ORG_CLASSIFICATION,
59: ORG_INFORMATION_TYPE,
60: MANDATORY_FLAG,
61: ENABLED_FLAG,

Line 95: from HR_ORG_INFO_TYPES_BY_CLASS

91: X_MANDATORY_FLAG in VARCHAR2
92: ) is
93: cursor c1 is select
94: MANDATORY_FLAG
95: from HR_ORG_INFO_TYPES_BY_CLASS
96: where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
97: and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
98: for update of ORG_CLASSIFICATION nowait;
99: begin

Line 122: update HR_ORG_INFO_TYPES_BY_CLASS set

118: X_LAST_UPDATED_BY in NUMBER,
119: X_LAST_UPDATE_LOGIN in NUMBER
120: ) is
121: begin
122: update HR_ORG_INFO_TYPES_BY_CLASS set
123: MANDATORY_FLAG = X_MANDATORY_FLAG,
124: ENABLED_FLAG = X_ENABLED_FLAG,
125: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
126: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 141: delete from HR_ORG_INFO_TYPES_BY_CLASS

137: X_ORG_CLASSIFICATION in VARCHAR2,
138: X_ORG_INFORMATION_TYPE in VARCHAR2
139: ) is
140: begin
141: delete from HR_ORG_INFO_TYPES_BY_CLASS
142: where ORG_CLASSIFICATION = X_ORG_CLASSIFICATION
143: and ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
144:
145: if (sql%notfound) then

Line 177: from HR_ORG_INFO_TYPES_BY_CLASS

173: -- Translate char last_update_date to date
174: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
175: select LAST_UPDATED_BY, LAST_UPDATE_DATE
176: into db_luby, db_ludate
177: from HR_ORG_INFO_TYPES_BY_CLASS
178: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
179: and ORG_CLASSIFICATION=X_ORG_CLASSIFICATION;
180:
181: -- Test for customization and version

Line 209: end HR_ORG_INFO_TYPES_BY_CLASS_PKG;

205: f_ludate ,
206: f_luby ,
207: 0 );
208: end LOAD_ROW;
209: end HR_ORG_INFO_TYPES_BY_CLASS_PKG;