APPS.AMS_USER_STATUSES_PKG dependencies on AMS_USER_STATUSES_B

Line 27: cursor C is select ROWID from AMS_USER_STATUSES_B

23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER,
25: X_APPLICATION_ID in NUMBER DEFAULT '530'
26: ) is
27: cursor C is select ROWID from AMS_USER_STATUSES_B
28: where USER_STATUS_ID = X_USER_STATUS_ID
29: ;
30: begin
31: insert into AMS_USER_STATUSES_B (

Line 31: insert into AMS_USER_STATUSES_B (

27: cursor C is select ROWID from AMS_USER_STATUSES_B
28: where USER_STATUS_ID = X_USER_STATUS_ID
29: ;
30: begin
31: insert into AMS_USER_STATUSES_B (
32: DEFAULT_FLAG,
33: SEEDED_FLAG,
34: USER_STATUS_ID,
35: OBJECT_VERSION_NUMBER,

Line 127: from AMS_USER_STATUSES_B

123: SYSTEM_STATUS_CODE,
124: ENABLED_FLAG,
125: START_DATE_ACTIVE,
126: END_DATE_ACTIVE
127: from AMS_USER_STATUSES_B
128: where USER_STATUS_ID = X_USER_STATUS_ID
129: for update of USER_STATUS_ID nowait;
130: recinfo c%rowtype;
131:

Line 211: from AMS_USER_STATUSES_B

207: /*08-May-2006 mayjain fix for bug 5166318*/
208: cursor count_def_flag (P_SYSTEM_STATUS_TYPE VARCHAR2, P_SYSTEM_STATUS_CODE VARCHAR2)
209: IS
210: select count(1)
211: from AMS_USER_STATUSES_B
212: where SYSTEM_STATUS_TYPE = P_SYSTEM_STATUS_TYPE and
213: SYSTEM_STATUS_CODE = P_SYSTEM_STATUS_CODE and
214: ENABLED_FLAG = 'Y' and
215: DEFAULT_FLAG = 'Y' and

Line 241: update AMS_USER_STATUSES_B set

237: END IF;
238: END IF;
239: /*08-May-2006 mayjain fix for bug 5166318*/
240:
241: update AMS_USER_STATUSES_B set
242: DEFAULT_FLAG = l_default_flag, /*08-May-2006 mayjain fix for bug 5166318*/
243: SEEDED_FLAG = X_SEEDED_FLAG,
244: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
245: SYSTEM_STATUS_TYPE = X_SYSTEM_STATUS_TYPE,

Line 286: delete from AMS_USER_STATUSES_B

282: if (sql%notfound) then
283: raise no_data_found;
284: end if;
285:
286: delete from AMS_USER_STATUSES_B
287: where USER_STATUS_ID = X_USER_STATUS_ID;
288:
289: if (sql%notfound) then
290: raise no_data_found;

Line 300: from AMS_USER_STATUSES_B B

296: begin
297: delete from AMS_USER_STATUSES_TL T
298: where not exists
299: (select NULL
300: from AMS_USER_STATUSES_B B
301: where B.USER_STATUS_ID = T.USER_STATUS_ID
302: );
303:
304: update AMS_USER_STATUSES_TL T set (

Line 425: from AMS_USER_STATUSES_B

421: l_db_luby_id number;
422: /*
423: cursor c_obj_verno is
424: select object_version_number
425: from AMS_USER_STATUSES_B
426: where user_status_id = X_USER_STATUS_ID;
427: */
428: cursor c_chk_ust_exists is
429: select 'x'

Line 430: from AMS_USER_STATUSES_B

426: where user_status_id = X_USER_STATUS_ID;
427: */
428: cursor c_chk_ust_exists is
429: select 'x'
430: from AMS_USER_STATUSES_B
431: where user_status_id = X_USER_STATUS_ID;
432:
433: cursor c_get_ust_id is
434: select AMS_USER_STATUSES_B_S.nextval

Line 434: select AMS_USER_STATUSES_B_S.nextval

430: from AMS_USER_STATUSES_B
431: where user_status_id = X_USER_STATUS_ID;
432:
433: cursor c_get_ust_id is
434: select AMS_USER_STATUSES_B_S.nextval
435: from dual;
436:
437: cursor c_db_data_details is
438: select last_updated_by, nvl(object_version_number,1)

Line 439: from AMS_USER_STATUSES_B

435: from dual;
436:
437: cursor c_db_data_details is
438: select last_updated_by, nvl(object_version_number,1)
439: from AMS_USER_STATUSES_B
440: where user_status_id = X_USER_STATUS_ID;
441: BEGIN
442:
443: -- set the last_updated_by to be used while updating the data in customer data.