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_STATUSES_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 141: from per_ass_status_type_amends a

137: and t.assignment_status_type_id = ttl.assignment_status_type_id
138: and ttl.LANGUAGE = userenv('LANG')
139: and not exists (
140: select null
141: from per_ass_status_type_amends a
142: where a.assignment_status_type_id =
143: t.assignment_status_type_id
144: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID);
145: CURSOR C2 IS

Line 147: from per_ass_status_type_amends_tl atl,

143: t.assignment_status_type_id
144: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID);
145: CURSOR C2 IS
146: select 1
147: from per_ass_status_type_amends_tl atl,
148: per_ass_status_type_amends a
149: where upper(atl.user_status) = upper(P_USER_STATUS)
150: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID
151: and a.ass_status_type_amend_id = atl.ass_status_type_amend_id

Line 148: per_ass_status_type_amends a

144: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID);
145: CURSOR C2 IS
146: select 1
147: from per_ass_status_type_amends_tl atl,
148: per_ass_status_type_amends a
149: where upper(atl.user_status) = upper(P_USER_STATUS)
150: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID
151: and a.ass_status_type_amend_id = atl.ass_status_type_amend_id
152: and atl.LANGUAGE = userenv('LANG')

Line 189: update per_ass_status_type_amends a

185: P_CREATION_DATE DATE,
186: P_ASS_STATUS_TYPE_ID NUMBER,
187: P_AMENDMENT VARCHAR2) IS
188: BEGIN
189: update per_ass_status_type_amends a
190: set a.active_flag = P_ACTIVE_FLAG,
191: a.default_flag = P_DEFAULT_FLAG,
192: a.user_status = P_USER_STATUS,
193: a.pay_system_status = P_PAY_SYSTEM_STATUS,

Line 201: update per_ass_status_type_amends_tl atl

197: a.created_by = P_CREATED_BY,
198: a.creation_date = P_CREATION_DATE
199: where a.ass_status_type_amend_id = P_ASS_STATUS_TYPE_ID;
200: --MLS
201: update per_ass_status_type_amends_tl atl
202: set atl.user_status = P_USER_STATUS,
203: atl.last_update_date = P_LAST_UPDATE_DATE,
204: atl.last_updated_by = P_LAST_UPDATED_BY,
205: atl.last_update_login = P_LAST_UPDATE_LOGIN,

Line 227: select per_ass_status_type_amends_s.nextval

223: P_CREATED_BY NUMBER,
224: P_CREATION_DATE DATE) IS
225: L_ID NUMBER;
226: BEGIN
227: select per_ass_status_type_amends_s.nextval
228: into L_ID
229: from sys.dual;
230: P_ASS_STATUS_TYPE_AMEND_ID := L_ID;
231:

Line 239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',

235: --
236:
237: BEGIN
238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(

Line 253: insert into per_ass_status_type_amends(

249: --
250: -- Code Ends Here.
251: --
252:
253: insert into per_ass_status_type_amends(
254: ASS_STATUS_TYPE_AMEND_ID,
255: ASSIGNMENT_STATUS_TYPE_ID,
256: BUSINESS_GROUP_ID,
257: ACTIVE_FLAG,

Line 290: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',

286: --
287:
288: BEGIN
289: PER_RIC_PKG.chk_integrity (
290: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',
291: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',
292: p_ref_column_name => 'ASS_STATUS_TYPE_AMEND_ID',
293: p_ref_col_value_number => P_ASS_STATUS_TYPE_AMEND_ID,
294: p_ref_col_value_varchar => NULL,

Line 291: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',

287:
288: BEGIN
289: PER_RIC_PKG.chk_integrity (
290: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',
291: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',
292: p_ref_column_name => 'ASS_STATUS_TYPE_AMEND_ID',
293: p_ref_col_value_number => P_ASS_STATUS_TYPE_AMEND_ID,
294: p_ref_col_value_varchar => NULL,
295: p_ref_col_value_date => NULL,

Line 302: insert into per_ass_status_type_amends_tl(

298: END;
299: --
300: -- Code Ends Here.
301: --
302: insert into per_ass_status_type_amends_tl(
303: ASS_STATUS_TYPE_AMEND_ID,
304: LANGUAGE,
305: SOURCE_LANG,
306: USER_STATUS,

Line 359: from per_ass_status_type_amends a

355: nvl(p_business_group_id, -9999)
356: and nvl(t.legislation_code, nvl(p_legislation_code, 'XXX') ) =
357: nvl(p_legislation_code, 'XXX')
358: and not exists (select null
359: from per_ass_status_type_amends a
360: where a.assignment_status_type_id =
361: t.assignment_status_type_id
362: and a.business_group_id =
363: p_business_group_id)

Line 366: from per_ass_status_type_amends a

362: and a.business_group_id =
363: p_business_group_id)
364: union all
365: select a.per_system_status status
366: from per_ass_status_type_amends a
367: where a.per_system_status is not null
368: and a.default_flag = 'Y'
369: and a.active_flag = 'Y'
370: and a.business_group_id = p_business_group_id

Line 703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(

699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(

Line 978: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

974: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
975: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
976: ));
977: */
978: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
979: ASS_STATUS_TYPE_AMEND_ID,
980: USER_STATUS,
981: LAST_UPDATE_DATE,
982: LAST_UPDATED_BY,

Line 998: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L

994: B.CREATED_BY,
995: B.CREATION_DATE,
996: L.LANGUAGE_CODE,
997: B.SOURCE_LANG
998: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L
999: where L.INSTALLED_FLAG in ('I', 'B')
1000: and B.LANGUAGE = userenv('LANG')
1001: and not exists
1002: (select NULL

Line 1003: from PER_ASS_STATUS_TYPE_AMENDS_TL T

999: where L.INSTALLED_FLAG in ('I', 'B')
1000: and B.LANGUAGE = userenv('LANG')
1001: and not exists
1002: (select NULL
1003: from PER_ASS_STATUS_TYPE_AMENDS_TL T
1004: where T.ASS_STATUS_TYPE_AMEND_ID = B.ASS_STATUS_TYPE_AMEND_ID
1005: and T.LANGUAGE = L.LANGUAGE_CODE);
1006: --
1007: end ADD_LANGUAGE;