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.2 2006/06/27 10:41:15 bshukla noship $ */
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 75: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

71: X_CREATION_DATE in DATE,
72: X_CREATED_BY in NUMBER
73: ) is
74: begin
75: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
76: ASS_STATUS_TYPE_AMEND_ID,
77: USER_STATUS,
78: LAST_UPDATE_DATE,
79: LAST_UPDATED_BY,

Line 99: from PER_ASS_STATUS_TYPE_AMENDS_TL

95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I','B')
97: and not exists (
98: select null
99: from PER_ASS_STATUS_TYPE_AMENDS_TL
100: where ASS_STATUS_TYPE_AMEND_ID = X_ASS_STATUS_TYPE_AMEND_ID
101: and LANGUAGE = L.LANGUAGE_CODE );
102: end INSERT_ROW;
103:

Line 114: update PER_ASS_STATUS_TYPE_AMENDS_TL

110: X_CREATION_DATE in DATE,
111: X_CREATED_BY in NUMBER
112: ) is
113: begin
114: update PER_ASS_STATUS_TYPE_AMENDS_TL
115: set USER_STATUS = X_USER_STATUS,
116: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
117: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
118: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 132: delete from PER_ASS_STATUS_TYPE_AMENDS_TL

128: procedure DELETE_ROW (
129: X_ASS_STATUS_TYPE_AMEND_ID in NUMBER
130: ) is
131: begin
132: delete from PER_ASS_STATUS_TYPE_AMENDS_TL
133: where ASS_STATUS_TYPE_AMEND_ID = X_ASS_STATUS_TYPE_AMEND_ID;
134:
135: if (sql%notfound) then
136: raise no_data_found;

Line 143: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T

139:
140: procedure ADD_LANGUAGE
141: is
142: begin
143: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T
144: where not exists
145: (select NULL
146: from PER_ASS_STATUS_TYPE_AMENDS B
147: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID

Line 146: from PER_ASS_STATUS_TYPE_AMENDS B

142: begin
143: delete from PER_ASS_STATUS_TYPE_AMENDS_TL T
144: where not exists
145: (select NULL
146: from PER_ASS_STATUS_TYPE_AMENDS B
147: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
148: );
149:
150: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (

Line 150: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (

146: from PER_ASS_STATUS_TYPE_AMENDS B
147: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
148: );
149:
150: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (
151: USER_STATUS
152: ) = (select B.USER_STATUS
153: from PER_ASS_STATUS_TYPE_AMENDS_TL B
154: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID

Line 153: from PER_ASS_STATUS_TYPE_AMENDS_TL B

149:
150: update PER_ASS_STATUS_TYPE_AMENDS_TL T set (
151: USER_STATUS
152: ) = (select B.USER_STATUS
153: from PER_ASS_STATUS_TYPE_AMENDS_TL B
154: where B.ASS_STATUS_TYPE_AMEND_ID = T.ASS_STATUS_TYPE_AMEND_ID
155: and B.LANGUAGE = T.SOURCE_LANG)
156: where (
157: T.ASS_STATUS_TYPE_AMEND_ID,

Line 162: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,

158: T.LANGUAGE
159: ) in (select
160: SUBT.ASS_STATUS_TYPE_AMEND_ID,
161: SUBT.LANGUAGE
162: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,
163: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT
164: where SUBB.ASS_STATUS_TYPE_AMEND_ID =
165: SUBT.ASS_STATUS_TYPE_AMEND_ID
166: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 163: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT

159: ) in (select
160: SUBT.ASS_STATUS_TYPE_AMEND_ID,
161: SUBT.LANGUAGE
162: from PER_ASS_STATUS_TYPE_AMENDS_TL SUBB,
163: PER_ASS_STATUS_TYPE_AMENDS_TL SUBT
164: where SUBB.ASS_STATUS_TYPE_AMEND_ID =
165: SUBT.ASS_STATUS_TYPE_AMEND_ID
166: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
167: and (SUBB.USER_STATUS <> SUBT.USER_STATUS));

Line 169: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

165: SUBT.ASS_STATUS_TYPE_AMEND_ID
166: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
167: and (SUBB.USER_STATUS <> SUBT.USER_STATUS));
168:
169: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
170: ASS_STATUS_TYPE_AMEND_ID,
171: USER_STATUS,
172: LAST_UPDATE_DATE,
173: LAST_UPDATED_BY,

Line 189: from PER_ASS_STATUS_TYPE_AMENDS_TL B,

185: B.CREATED_BY,
186: B.CREATION_DATE,
187: L.LANGUAGE_CODE,
188: B.SOURCE_LANG
189: from PER_ASS_STATUS_TYPE_AMENDS_TL B,
190: FND_LANGUAGES L
191: where L.INSTALLED_FLAG in ('I', 'B')
192: and B.LANGUAGE = userenv('LANG')
193: and not exists

Line 195: from PER_ASS_STATUS_TYPE_AMENDS_TL T

191: where L.INSTALLED_FLAG in ('I', 'B')
192: and B.LANGUAGE = userenv('LANG')
193: and not exists
194: (select NULL
195: from PER_ASS_STATUS_TYPE_AMENDS_TL T
196: where T.ASS_STATUS_TYPE_AMEND_ID = B.ASS_STATUS_TYPE_AMEND_ID
197: and T.LANGUAGE = L.LANGUAGE_CODE);
198: end ADD_LANGUAGE;
199:

Line 249: from PER_ASS_STATUS_TYPE_AMENDS

245: -- Translate char last_update_date to date
246: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
247: select LAST_UPDATED_BY, LAST_UPDATE_DATE
248: into db_luby, db_ludate
249: from PER_ASS_STATUS_TYPE_AMENDS
250: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID);
251:
252: -- Test for customization and version
253: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 325: from PER_ASS_STATUS_TYPE_AMENDS_TL

321: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
322:
323: select LAST_UPDATED_BY, LAST_UPDATE_DATE
324: into db_luby, db_ludate
325: from PER_ASS_STATUS_TYPE_AMENDS_TL
326: where ASS_STATUS_TYPE_AMEND_ID = TO_NUMBER(X_ASS_STATUS_TYPE_AMEND_ID)
327: and LANGUAGE=userenv('LANG');
328:
329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 331: update PER_ASS_STATUS_TYPE_AMENDS_TL set

327: and LANGUAGE=userenv('LANG');
328:
329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
330: db_ludate,X_CUSTOM_MODE)) then
331: update PER_ASS_STATUS_TYPE_AMENDS_TL set
332: USER_STATUS = X_USER_STATUS,
333: LAST_UPDATE_DATE = db_ludate,
334: LAST_UPDATED_BY = db_luby,
335: LAST_UPDATE_LOGIN = 0,

Line 343: end PER_ASS_STATUS_TYPE_AMENDS_PKG;

339:
340: end if;
341: end TRANSLATE_ROW;
342:
343: end PER_ASS_STATUS_TYPE_AMENDS_PKG;