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_PRD_TYPES_HIER_PKG dependencies on FEM_DIS_PRD_TYPES_HIER_B

Line 115: cursor C is select ROWID from FEM_DIS_PRD_TYPES_HIER_B

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

Line 140: insert into FEM_DIS_PRD_TYPES_HIER_B (

136: and LEVEL19_ID = X_LEVEL19_ID
137: and LEVEL20_ID = X_LEVEL20_ID
138: ;
139: begin
140: insert into FEM_DIS_PRD_TYPES_HIER_B (
141: LEVEL8_DISPLAY_ORDER_NUM,
142: LEVEL9_DISPLAY_ORDER_NUM,
143: LEVEL10_DISPLAY_ORDER_NUM,
144: LEVEL11_DISPLAY_ORDER_NUM,

Line 608: from FEM_DIS_PRD_TYPES_HIER_B

604: LEVEL4_DISPLAY_ORDER_NUM,
605: LEVEL5_DISPLAY_ORDER_NUM,
606: LEVEL6_DISPLAY_ORDER_NUM,
607: LEVEL7_DISPLAY_ORDER_NUM
608: from FEM_DIS_PRD_TYPES_HIER_B
609: where OBJECT_ID = X_OBJECT_ID
610: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
611: and LEVEL1_ID = X_LEVEL1_ID
612: and LEVEL2_ID = X_LEVEL2_ID

Line 944: update FEM_DIS_PRD_TYPES_HIER_B set

940: X_LAST_UPDATED_BY in NUMBER,
941: X_LAST_UPDATE_LOGIN in NUMBER
942: ) is
943: begin
944: update FEM_DIS_PRD_TYPES_HIER_B set
945: LEVEL8_DISPLAY_ORDER_NUM = X_LEVEL8_DISPLAY_ORDER_NUM,
946: LEVEL9_DISPLAY_ORDER_NUM = X_LEVEL9_DISPLAY_ORDER_NUM,
947: LEVEL10_DISPLAY_ORDER_NUM = X_LEVEL10_DISPLAY_ORDER_NUM,
948: LEVEL11_DISPLAY_ORDER_NUM = X_LEVEL11_DISPLAY_ORDER_NUM,

Line 1144: delete from FEM_DIS_PRD_TYPES_HIER_B

1140: if (sql%notfound) then
1141: raise no_data_found;
1142: end if;
1143:
1144: delete from FEM_DIS_PRD_TYPES_HIER_B
1145: where OBJECT_ID = X_OBJECT_ID
1146: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
1147: and LEVEL1_ID = X_LEVEL1_ID
1148: and LEVEL2_ID = X_LEVEL2_ID

Line 1179: from FEM_DIS_PRD_TYPES_HIER_B B

1175: begin
1176: delete from FEM_DIS_PRD_TYPES_HIER_TL T
1177: where not exists
1178: (select NULL
1179: from FEM_DIS_PRD_TYPES_HIER_B B
1180: where B.OBJECT_ID = T.OBJECT_ID
1181: and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
1182: and B.LEVEL1_ID = T.LEVEL1_ID
1183: and B.LEVEL2_ID = T.LEVEL2_ID