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.MTL_CATEGORY_SETS_PKG dependencies on MTL_CATEGORY_SETS_B

Line 32: from MTL_CATEGORY_SETS_B

28: ) is
29:
30: cursor C is
31: select ROWID
32: from MTL_CATEGORY_SETS_B
33: where CATEGORY_SET_ID = X_CATEGORY_SET_ID ;
34:
35: begin
36:

Line 37: insert into MTL_CATEGORY_SETS_B (

33: where CATEGORY_SET_ID = X_CATEGORY_SET_ID ;
34:
35: begin
36:
37: insert into MTL_CATEGORY_SETS_B (
38: CATEGORY_SET_ID,
39: STRUCTURE_ID,
40: VALIDATE_FLAG,
41: MULT_ITEM_CAT_ASSIGN_FLAG,

Line 137: from MTL_CATEGORY_SETS_B

133: MULT_ITEM_CAT_ASSIGN_FLAG,
134: CONTROL_LEVEL,
135: DEFAULT_CATEGORY_ID
136: -- REQUEST_ID,
137: from MTL_CATEGORY_SETS_B
138: where CATEGORY_SET_ID = X_CATEGORY_SET_ID
139: for update of CATEGORY_SET_ID nowait ;
140:
141: recinfo c%rowtype;

Line 224: update MTL_CATEGORY_SETS_B set

220: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
221: l_miss_num NUMBER := FND_API.G_MISS_NUM;
222: BEGIN
223:
224: update MTL_CATEGORY_SETS_B set
225: STRUCTURE_ID = DECODE(X_STRUCTURE_ID,l_miss_num,STRUCTURE_ID,X_STRUCTURE_ID),
226: VALIDATE_FLAG = DECODE(X_VALIDATE_FLAG,l_miss_char,VALIDATE_FLAG,X_VALIDATE_FLAG),
227: MULT_ITEM_CAT_ASSIGN_FLAG = DECODE(X_MULT_ITEM_CAT_ASSIGN_FLAG,l_miss_char,MULT_ITEM_CAT_ASSIGN_FLAG,X_MULT_ITEM_CAT_ASSIGN_FLAG),
228: CONTROL_LEVEL_UPDATEABLE_FLAG = DECODE(UPPER(X_CONTROL_LEVEL_UPDT_FLAG),'N','N',NULL),

Line 280: delete from MTL_CATEGORY_SETS_B

276: if (sql%notfound) then
277: raise no_data_found;
278: end if;
279:
280: delete from MTL_CATEGORY_SETS_B
281: where CATEGORY_SET_ID = X_CATEGORY_SET_ID;
282:
283: if (sql%notfound) then
284: raise no_data_found;

Line 302: from MTL_CATEGORY_SETS_B B

298:
299: delete from MTL_CATEGORY_SETS_TL T
300: where not exists
301: ( select NULL
302: from MTL_CATEGORY_SETS_B B
303: where B.CATEGORY_SET_ID = T.CATEGORY_SET_ID
304: );
305:
306: update MTL_CATEGORY_SETS_TL T set (

Line 469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;

465: f_luby NUMBER; -- entity owner in file
466: f_ludate DATE; -- entity update date in file
467: db_luby NUMBER; -- entity owner in db
468: db_ludate DATE; -- entity update date in db
469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;
470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;

Line 470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;

466: f_ludate DATE; -- entity update date in file
467: db_luby NUMBER; -- entity owner in db
468: db_ludate DATE; -- entity update date in db
469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;
470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;

Line 471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;

467: db_luby NUMBER; -- entity owner in db
468: db_ludate DATE; -- entity update date in db
469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;
470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;

Line 472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;

468: db_ludate DATE; -- entity update date in db
469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;
470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;

Line 473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;

469: db_control_updt_flag MTL_CATEGORY_SETS_B.CONTROL_LEVEL_UPDATEABLE_FLAG%TYPE;
470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;

Line 474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;

470: db_mult_item_cat_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_UPDATEABLE_FLAG%TYPE;
471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;

Line 475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;

471: db_validate_updteable_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG_UPDATEABLE_FLAG%TYPE;
472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
479: l_control_flag_changed BOOLEAN;

Line 476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;

472: db_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
479: l_control_flag_changed BOOLEAN;
480: l_mult_item_flag_changed BOOLEAN;

Line 477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;

473: db_hierarchy_enabled MTL_CATEGORY_SETS_B.HIERARCHY_ENABLED%TYPE;
474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
479: l_control_flag_changed BOOLEAN;
480: l_mult_item_flag_changed BOOLEAN;
481: l_validate_flag_changed BOOLEAN;

Line 478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;

474: db_mult_item_Cat_assign_flag MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
475: db_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
476: l_mult_item_cat_assign MTL_CATEGORY_SETS_B.MULT_ITEM_CAT_ASSIGN_FLAG%TYPE;
477: l_validate_flag MTL_CATEGORY_SETS_B.VALIDATE_FLAG%TYPE;
478: l_control_level MTL_CATEGORY_SETS_B.CONTROL_LEVEL%TYPE;
479: l_control_flag_changed BOOLEAN;
480: l_mult_item_flag_changed BOOLEAN;
481: l_validate_flag_changed BOOLEAN;
482: l_select VARCHAR2(10);

Line 512: FROM MTL_CATEGORY_SETS_B

508: db_validate_flag,
509: db_hierarchy_enabled,
510: db_mult_item_Cat_assign_flag,
511: db_control_level
512: FROM MTL_CATEGORY_SETS_B
513: WHERE CATEGORY_SET_ID = x_category_set_id ;
514:
515: l_mult_item_flag_changed := false;
516: l_control_flag_changed := false;