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: insert into per_ass_status_type_amends(

Line 231: insert into per_ass_status_type_amends(

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: insert into per_ass_status_type_amends(
232: ASS_STATUS_TYPE_AMEND_ID,
233: ASSIGNMENT_STATUS_TYPE_ID,
234: BUSINESS_GROUP_ID,
235: ACTIVE_FLAG,

Line 260: insert into per_ass_status_type_amends_tl(

256: P_LAST_UPDATE_LOGIN,
257: P_CREATED_BY,
258: P_CREATION_DATE);
259: -- MLS
260: insert into per_ass_status_type_amends_tl(
261: ASS_STATUS_TYPE_AMEND_ID,
262: LANGUAGE,
263: SOURCE_LANG,
264: USER_STATUS,

Line 317: from per_ass_status_type_amends a

313: nvl(p_business_group_id, -9999)
314: and nvl(t.legislation_code, nvl(p_legislation_code, 'XXX') ) =
315: nvl(p_legislation_code, 'XXX')
316: and not exists (select null
317: from per_ass_status_type_amends a
318: where a.assignment_status_type_id =
319: t.assignment_status_type_id
320: and a.business_group_id =
321: p_business_group_id)

Line 324: from per_ass_status_type_amends a

320: and a.business_group_id =
321: p_business_group_id)
322: union all
323: select a.per_system_status status
324: from per_ass_status_type_amends a
325: where a.per_system_status is not null
326: and a.default_flag = 'Y'
327: and a.active_flag = 'Y'
328: and a.business_group_id = p_business_group_id

Line 891: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

887: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
888: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
889: ));
890: */
891: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
892: ASS_STATUS_TYPE_AMEND_ID,
893: USER_STATUS,
894: LAST_UPDATE_DATE,
895: LAST_UPDATED_BY,

Line 911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L

907: B.CREATED_BY,
908: B.CREATION_DATE,
909: L.LANGUAGE_CODE,
910: B.SOURCE_LANG
911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L
912: where L.INSTALLED_FLAG in ('I', 'B')
913: and B.LANGUAGE = userenv('LANG')
914: and not exists
915: (select NULL

Line 916: from PER_ASS_STATUS_TYPE_AMENDS_TL T

912: where L.INSTALLED_FLAG in ('I', 'B')
913: and B.LANGUAGE = userenv('LANG')
914: and not exists
915: (select NULL
916: from PER_ASS_STATUS_TYPE_AMENDS_TL T
917: where T.ASS_STATUS_TYPE_AMEND_ID = B.ASS_STATUS_TYPE_AMEND_ID
918: and T.LANGUAGE = L.LANGUAGE_CODE);
919: --
920: end ADD_LANGUAGE;