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.FEM_DIS_USR_DIM6_HIER_PKG dependencies on FEM_DIS_USR_DIM6_HIER_B

Line 116: cursor C is select ROWID from FEM_DIS_USR_DIM6_HIER_B

112: X_LAST_UPDATE_DATE in DATE,
113: X_LAST_UPDATED_BY in NUMBER,
114: X_LAST_UPDATE_LOGIN in NUMBER
115: ) is
116: cursor C is select ROWID from FEM_DIS_USR_DIM6_HIER_B
117: where OBJECT_ID = X_OBJECT_ID
118: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
119: and VALUE_SET_ID = X_VALUE_SET_ID
120: and LEVEL1_ID = X_LEVEL1_ID

Line 142: insert into FEM_DIS_USR_DIM6_HIER_B (

138: and LEVEL19_ID = X_LEVEL19_ID
139: and LEVEL20_ID = X_LEVEL20_ID
140: ;
141: begin
142: insert into FEM_DIS_USR_DIM6_HIER_B (
143: OBJECT_ID,
144: OBJECT_DEFINITION_ID,
145: VALUE_SET_ID,
146: LEVEL1_ID,

Line 616: from FEM_DIS_USR_DIM6_HIER_B

612: LEVEL17_DISPLAY_ORDER_NUM,
613: LEVEL18_DISPLAY_ORDER_NUM,
614: LEVEL19_DISPLAY_ORDER_NUM,
615: LEVEL20_DISPLAY_ORDER_NUM
616: from FEM_DIS_USR_DIM6_HIER_B
617: where OBJECT_ID = X_OBJECT_ID
618: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
619: and VALUE_SET_ID = X_VALUE_SET_ID
620: and LEVEL1_ID = X_LEVEL1_ID

Line 955: update FEM_DIS_USR_DIM6_HIER_B set

951: X_LAST_UPDATED_BY in NUMBER,
952: X_LAST_UPDATE_LOGIN in NUMBER
953: ) is
954: begin
955: update FEM_DIS_USR_DIM6_HIER_B set
956: LEVEL1_DISPLAY_CODE = X_LEVEL1_DISPLAY_CODE,
957: LEVEL2_DISPLAY_CODE = X_LEVEL2_DISPLAY_CODE,
958: LEVEL3_DISPLAY_CODE = X_LEVEL3_DISPLAY_CODE,
959: LEVEL4_DISPLAY_CODE = X_LEVEL4_DISPLAY_CODE,

Line 1159: delete from FEM_DIS_USR_DIM6_HIER_B

1155: if (sql%notfound) then
1156: raise no_data_found;
1157: end if;
1158:
1159: delete from FEM_DIS_USR_DIM6_HIER_B
1160: where OBJECT_ID = X_OBJECT_ID
1161: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
1162: and VALUE_SET_ID = X_VALUE_SET_ID
1163: and LEVEL1_ID = X_LEVEL1_ID

Line 1195: from FEM_DIS_USR_DIM6_HIER_B B

1191: begin
1192: delete from FEM_DIS_USR_DIM6_HIER_TL T
1193: where not exists
1194: (select NULL
1195: from FEM_DIS_USR_DIM6_HIER_B B
1196: where B.OBJECT_ID = T.OBJECT_ID
1197: and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
1198: and B.VALUE_SET_ID = T.VALUE_SET_ID
1199: and B.LEVEL1_ID = T.LEVEL1_ID