eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASS_STATUS_TYPE_AMENDS_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1: package body PER_ASS_STATUS_TYPE_AMENDS_PKG as

1: package body PER_ASS_STATUS_TYPE_AMENDS_PKG as
2: /* $Header: peastamd.pkb 120.3 2011/04/28 10:15:37 sidsaxen ship $ */
3: procedure KEY_TO_IDS (
4: X_USER_STATUS in VARCHAR2,
5: X_BUSINESS_GROUP_NAME in VARCHAR2,

Line 22: from PER_ASS_STATUS_TYPE_AMENDS

18: L_BUSINESS_GROUP_ID in NUMBER
19: ) is
20:
21: select ASS_STATUS_TYPE_AMEND_ID
22: from PER_ASS_STATUS_TYPE_AMENDS
23: where USER_STATUS = L_STATUS
24: and BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
25:
26: L_BUSINESS_GROUP_ID NUMBER;

Line 83: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',

79: --
80:
81: BEGIN
82: PER_RIC_PKG.chk_integrity (
83: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',
84: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',
85: p_ref_column_name => 'ASS_STATUS_TYPE_AMEND_ID',
86: p_ref_col_value_number => X_ASS_STATUS_TYPE_AMEND_ID,
87: p_ref_col_value_varchar => NULL,

Line 84: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',

80:
81: BEGIN
82: PER_RIC_PKG.chk_integrity (
83: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',
84: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',
85: p_ref_column_name => 'ASS_STATUS_TYPE_AMEND_ID',
86: p_ref_col_value_number => X_ASS_STATUS_TYPE_AMEND_ID,
87: p_ref_col_value_varchar => NULL,
88: p_ref_col_value_date => NULL,

Line 96: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

92: --
93: -- Code Ends Here.
94: --
95:
96: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
97: ASS_STATUS_TYPE_AMEND_ID,
98: USER_STATUS,
99: LAST_UPDATE_DATE,
100: LAST_UPDATED_BY,

Line 120: from PER_ASS_STATUS_TYPE_AMENDS_TL

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I','B')
118: and not exists (
119: select null
120: from PER_ASS_STATUS_TYPE_AMENDS_TL
121: where ASS_STATUS_TYPE_AMEND_ID = X_ASS_STATUS_TYPE_AMEND_ID
122: and LANGUAGE = L.LANGUAGE_CODE );
123: end INSERT_ROW;
124:

Line 135: update PER_ASS_STATUS_TYPE_AMENDS_TL

131: X_CREATION_DATE in DATE,
132: X_CREATED_BY in NUMBER
133: ) is
134: begin
135: update PER_ASS_STATUS_TYPE_AMENDS_TL
136: set USER_STATUS = X_USER_STATUS,
137: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
139: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 153: delete from PER_ASS_STATUS_TYPE_AMENDS_TL

149: procedure DELETE_ROW (
150: X_ASS_STATUS_TYPE_AMEND_ID in NUMBER
151: ) is
152: begin
153: delete from PER_ASS_STATUS_TYPE_AMENDS_TL
154: where ASS_STATUS_TYPE_AMEND_ID = X_ASS_STATUS_TYPE_AMEND_ID;
155:
156: if (sql%notfound) then
157: raise no_data_found;

Line 164: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T

160:
161: procedure ADD_LANGUAGE
162: is
163: begin
164: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T
165: where not exists
166: (select NULL
167: from PER_ASS_STATUS_TYPE_AMENDS B
168: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID

Line 167: from PER_ASS_STATUS_TYPE_AMENDS B

163: begin
164: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T
165: where not exists
166: (select NULL
167: from PER_ASS_STATUS_TYPE_AMENDS B
168: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
169: );
170:
171: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (

Line 171: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (

167: from PER_ASS_STATUS_TYPE_AMENDS B
168: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
169: );
170:
171: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (
172: USER_STATUS
173: ) = (select B.USER_STATUS
174: from PER_ASS_STATUS_TYPE_AMENDS_TL B
175: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID

Line 174: from PER_ASS_STATUS_TYPE_AMENDS_TL B

170:
171: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (
172: USER_STATUS
173: ) = (select B.USER_STATUS
174: from PER_ASS_STATUS_TYPE_AMENDS_TL B
175: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
176: and B.LANGUAGE = T.SOURCE_LANG)
177: where (
178: T.ASS_STATUS_TYPE_AMEND_ID,

Line 183: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,

179: T.LANGUAGE
180: ) in (select
181: SUBT.ASS_STATUS_TYPE_AMEND_ID,
182: SUBT.LANGUAGE
183: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,
184: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT
185: where SUBB.ASS_STATUS_TYPE_AMEND_ID =
186: SUBT.ASS_STATUS_TYPE_AMEND_ID
187: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 184: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT

180: ) in (select
181: SUBT.ASS_STATUS_TYPE_AMEND_ID,
182: SUBT.LANGUAGE
183: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,
184: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT
185: where SUBB.ASS_STATUS_TYPE_AMEND_ID =
186: SUBT.ASS_STATUS_TYPE_AMEND_ID
187: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
188: and (SUBB.USER_STATUS <> SUBT.USER_STATUS));

Line 190: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

186: SUBT.ASS_STATUS_TYPE_AMEND_ID
187: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
188: and (SUBB.USER_STATUS <> SUBT.USER_STATUS));
189:
190: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
191: ASS_STATUS_TYPE_AMEND_ID,
192: USER_STATUS,
193: LAST_UPDATE_DATE,
194: LAST_UPDATED_BY,

Line 210: from PER_ASS_STATUS_TYPE_AMENDS_TL B,

206: B.CREATED_BY,
207: B.CREATION_DATE,
208: L.LANGUAGE_CODE,
209: B.SOURCE_LANG
210: from PER_ASS_STATUS_TYPE_AMENDS_TL B,
211: FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists

Line 216: from PER_ASS_STATUS_TYPE_AMENDS_TL T

212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists
215: (select NULL
216: from PER_ASS_STATUS_TYPE_AMENDS_TL T
217: where T.ASS_STATUS_TYPE_AMEND_ID = B.ASS_STATUS_TYPE_AMEND_ID
218: and T.LANGUAGE = L.LANGUAGE_CODE);
219: end ADD_LANGUAGE;
220:

Line 270: from PER_ASS_STATUS_TYPE_AMENDS

266: -- Translate char last_update_date to date
267: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
268: select LAST_UPDATED_BY, LAST_UPDATE_DATE
269: into db_luby, db_ludate
270: from PER_ASS_STATUS_TYPE_AMENDS
271: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID);
272:
273: -- Test for customization and version
274: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 346: from PER_ASS_STATUS_TYPE_AMENDS_TL

342: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
343:
344: select LAST_UPDATED_BY, LAST_UPDATE_DATE
345: into db_luby, db_ludate
346: from PER_ASS_STATUS_TYPE_AMENDS_TL
347: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID)
348: and LANGUAGE=userenv('LANG');
349:
350: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 352: update PER_ASS_STATUS_TYPE_AMENDS_TL set

348: and LANGUAGE=userenv('LANG');
349:
350: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
351: db_ludate,X_CUSTOM_MODE)) then
352: update PER_ASS_STATUS_TYPE_AMENDS_TL set
353: USER_STATUS = X_USER_STATUS,
354: LAST_UPDATE_DATE = db_ludate,
355: LAST_UPDATED_BY = db_luby,
356: LAST_UPDATE_LOGIN = 0,

Line 364: end PER_ASS_STATUS_TYPE_AMENDS_PKG;

360:
361: end if;
362: end TRANSLATE_ROW;
363:
364: end PER_ASS_STATUS_TYPE_AMENDS_PKG;