APPS.AMS_CATEGORIES_PKG dependencies on AMS_CATEGORIES_B

Line 36: cursor C is select ROWID from AMS_CATEGORIES_B

32: X_LAST_UPDATE_LOGIN in NUMBER,
33: X_ACCRUED_LIABILITY_ACCOUNT in NUMBER,
34: X_DED_ADJUSTMENT_ACCOUNT in NUMBER
35: ) is
36: cursor C is select ROWID from AMS_CATEGORIES_B
37: where CATEGORY_ID = X_CATEGORY_ID
38: ;
39: begin
40: insert into AMS_CATEGORIES_B (

Line 40: insert into AMS_CATEGORIES_B (

36: cursor C is select ROWID from AMS_CATEGORIES_B
37: where CATEGORY_ID = X_CATEGORY_ID
38: ;
39: begin
40: insert into AMS_CATEGORIES_B (
41: CATEGORY_ID,
42: OBJECT_VERSION_NUMBER,
43: ARC_CATEGORY_CREATED_FOR,
44: ENABLED_FLAG,

Line 190: from AMS_CATEGORIES_B

186: ATTRIBUTE14,
187: ATTRIBUTE15,
188: ACCRUED_LIABILITY_ACCOUNT,
189: DED_ADJUSTMENT_ACCOUNT
190: from AMS_CATEGORIES_B
191: where CATEGORY_ID = X_CATEGORY_ID
192: for update of CATEGORY_ID nowait;
193: recinfo c%rowtype;
194:

Line 309: update AMS_CATEGORIES_B set

305: X_ACCRUED_LIABILITY_ACCOUNT in NUMBER,
306: X_DED_ADJUSTMENT_ACCOUNT in NUMBER
307: ) is
308: begin
309: update AMS_CATEGORIES_B set
310: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
311: ARC_CATEGORY_CREATED_FOR = X_ARC_CATEGORY_CREATED_FOR,
312: ENABLED_FLAG = X_ENABLED_FLAG,
313: PARENT_CATEGORY_ID = X_PARENT_CATEGORY_ID,

Line 367: delete from AMS_CATEGORIES_B

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: delete from AMS_CATEGORIES_B
368: where CATEGORY_ID = X_CATEGORY_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 381: from AMS_CATEGORIES_B B

377: begin
378: delete from AMS_CATEGORIES_TL T
379: where not exists
380: (select NULL
381: from AMS_CATEGORIES_B B
382: where B.CATEGORY_ID = T.CATEGORY_ID
383: );
384:
385: update AMS_CATEGORIES_TL T set (

Line 498: from AMS_CATEGORIES_B

494:
495:
496: cursor c_db_data_details is
497: select last_updated_by, nvl(object_version_number,1)
498: from AMS_CATEGORIES_B
499: where category_id = X_CATEGORY_ID;
500: /*
501: cursor c_obj_verno is
502: select object_version_number

Line 503: from AMS_CATEGORIES_B

499: where category_id = X_CATEGORY_ID;
500: /*
501: cursor c_obj_verno is
502: select object_version_number
503: from AMS_CATEGORIES_B
504: where category_id = X_CATEGORY_ID;
505: */
506: cursor c_chk_cty_exists is
507: select 'x'

Line 508: from AMS_CATEGORIES_B

504: where category_id = X_CATEGORY_ID;
505: */
506: cursor c_chk_cty_exists is
507: select 'x'
508: from AMS_CATEGORIES_B
509: where category_id = X_CATEGORY_ID;
510:
511: cursor c_get_ctyid is
512: select AMS_CATEGORIES_B_S.nextval

Line 512: select AMS_CATEGORIES_B_S.nextval

508: from AMS_CATEGORIES_B
509: where category_id = X_CATEGORY_ID;
510:
511: cursor c_get_ctyid is
512: select AMS_CATEGORIES_B_S.nextval
513: from dual;
514:
515: BEGIN
516: