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.AK_PAGE_REGION_RELATIONS_PKG dependencies on AK_FLOW_REGION_RELATIONS

Line 23: insert into AK_FLOW_REGION_RELATIONS (

19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: begin
23: insert into AK_FLOW_REGION_RELATIONS (
24: FLOW_APPLICATION_ID,
25: FLOW_CODE,
26: FOREIGN_KEY_NAME,
27: FROM_PAGE_APPL_ID,

Line 77: from AK_FLOW_REGION_RELATIONS

73: X_OLD_TO_REGION_CODE in VARCHAR2
74: ) is
75: cursor c is select
76: FLOW_APPLICATION_ID
77: from AK_FLOW_REGION_RELATIONS
78: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
79: and FLOW_CODE = X_FLOW_CODE
80: and FOREIGN_KEY_NAME = X_OLD_FOREIGN_KEY_NAME
81: and FROM_PAGE_APPL_ID = X_FROM_PAGE_APPL_ID

Line 131: update AK_FLOW_REGION_RELATIONS set

127: X_LAST_UPDATED_BY in NUMBER,
128: X_LAST_UPDATE_LOGIN in NUMBER
129: ) is
130: begin
131: update AK_FLOW_REGION_RELATIONS set
132: FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID,
133: FLOW_CODE = X_FLOW_CODE,
134: FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME,
135: FROM_PAGE_APPL_ID = X_FROM_PAGE_APPL_ID,

Line 178: delete from AK_FLOW_REGION_RELATIONS

174: X_TO_REGION_APPL_ID in NUMBER,
175: X_TO_REGION_CODE in VARCHAR2
176: ) is
177: begin
178: delete from AK_FLOW_REGION_RELATIONS
179: where FLOW_APPLICATION_ID = X_FLOW_APPLICATION_ID
180: and FLOW_CODE = X_FLOW_CODE
181: and FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
182: and FROM_PAGE_APPL_ID = X_FROM_PAGE_APPL_ID