APPS.PER_ASS_STATUSES_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

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 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 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 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 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;