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.ADX_PRF_PKG dependencies on TAB

Line 79: tablename varchar2(100);

75: when no_data_found then null;
76: end;
77:
78: declare
79: tablename varchar2(100);
80: begin
81: select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');
82: exception WHEN NO_DATA_FOUND THEN
83: execute immediate 'create table ADX_PRE_AUTOCONFIG (

Line 81: select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');

77:
78: declare
79: tablename varchar2(100);
80: begin
81: select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');
82: exception WHEN NO_DATA_FOUND THEN
83: execute immediate 'create table ADX_PRE_AUTOCONFIG (
84: application_id number,
85: profile_option_name varchar2(100),

Line 83: execute immediate 'create table ADX_PRE_AUTOCONFIG (

79: tablename varchar2(100);
80: begin
81: select tname into tablename from tab where tname ='ADX_PRE_AUTOCONFIG' and tabtype in ('TABLE', 'SYNONYM');
82: exception WHEN NO_DATA_FOUND THEN
83: execute immediate 'create table ADX_PRE_AUTOCONFIG (
84: application_id number,
85: profile_option_name varchar2(100),
86: level_id number,
87: level_value number,

Line 97: -- Add the column LEVEL_VALUE2 to the table ADX_PRE_AUTOCONFIG if

93: level_value2 varchar2(100)
94: )';
95: end;
96:
97: -- Add the column LEVEL_VALUE2 to the table ADX_PRE_AUTOCONFIG if
98: -- the table does not have this column and
99: -- the profile value is to be updated at the SERVRESP level
100: declare
101: columnname varchar2(100);

Line 98: -- the table does not have this column and

94: )';
95: end;
96:
97: -- Add the column LEVEL_VALUE2 to the table ADX_PRE_AUTOCONFIG if
98: -- the table does not have this column and
99: -- the profile value is to be updated at the SERVRESP level
100: declare
101: columnname varchar2(100);
102: begin

Line 104: select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2';

100: declare
101: columnname varchar2(100);
102: begin
103: if (p_level_value2 is not NULL) then
104: select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2';
105: end if;
106: exception WHEN NO_DATA_FOUND THEN
107: execute immediate 'alter table ADX_PRE_AUTOCONFIG
108: add (level_value2 varchar2(100))';

Line 107: execute immediate 'alter table ADX_PRE_AUTOCONFIG

103: if (p_level_value2 is not NULL) then
104: select column_name into columnname from user_tab_columns where table_name like 'ADX_PRE_AUTOCONFIG' and column_name like 'LEVEL_VALUE2';
105: end if;
106: exception WHEN NO_DATA_FOUND THEN
107: execute immediate 'alter table ADX_PRE_AUTOCONFIG
108: add (level_value2 varchar2(100))';
109: end;
110: level_value_app_id_temp := p_level_value_app_id;
111: if level_value_app_id_temp = '' then

Line 150: -- Update the ADX_PRE_AUTOCONFIG table for rollback

146: end if;
147: end if;
148:
149: --
150: -- Update the ADX_PRE_AUTOCONFIG table for rollback
151: -- purposes.
152: --
153: declare
154: str varchar2(700);

Line 172: if (countrow>0) then -- update table since row already exist

168: execute immediate str INTO countrow
169: using p_application_id, p_profile_option_name, p_level_id,
170: p_level_value, p_context_name,update_flag,insert_flag;
171:
172: if (countrow>0) then -- update table since row already exist
173: str := 'update ADX_PRE_AUTOCONFIG set
174: profile_value=:1 where
175: application_id=:2 and profile_option_name=:3 and
176: level_id=:4 and level_value=:5 and

Line 184: else -- insert new row into table since one does not exist yet

180: using old_pv_rec.profile_option_value, p_application_id,
181: p_profile_option_name, p_level_id, p_level_value,
182: p_context_name, update_flag, insert_flag;
183:
184: else -- insert new row into table since one does not exist yet
185: str:='insert into ADX_PRE_AUTOCONFIG
186: (application_id, profile_option_name,
187: level_id,level_value,profile_value,
188: level_value_app_id,context_name,

Line 199: -- fnd_profile_option_values table

195: insert_flag;
196: end if;
197:
198: -- Call FND API to update/insert the profile option value in the
199: -- fnd_profile_option_values table
200: -- Note that for setting profiles at the SITE level
201: -- the last 3 parameters defined in the SAVE api are not required.
202:
203: ret_value := FND_PROFILE.SAVE(p_profile_option_name,

Line 223: if (countrow>0) then -- update table since row already exist

219: using p_application_id, p_profile_option_name, p_level_id,
220: p_level_value, level_value_app_id_temp, p_context_name,
221: update_flag,insert_flag, p_level_value2;
222:
223: if (countrow>0) then -- update table since row already exist
224: str := 'update ADX_PRE_AUTOCONFIG set
225: profile_value=:1 where
226: application_id=:2 and profile_option_name=:3 and
227: level_id=:4 and level_value=:5 and

Line 237: else -- insert new row into table since one does not exist yet

233: p_profile_option_name, p_level_id, p_level_value,
234: level_value_app_id_temp, p_context_name, update_flag,
235: insert_flag, p_level_value2;
236:
237: else -- insert new row into table since one does not exist yet
238: str:='insert into ADX_PRE_AUTOCONFIG
239: values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)';
240: execute immediate str
241: using p_application_id, p_profile_option_name, p_level_id,

Line 248: -- fnd_profile_option_values table

244: insert_flag, p_level_value2;
245: end if;
246:
247: -- Call FND API to update/insert the profile option value in the
248: -- fnd_profile_option_values table
249:
250: ret_value := FND_PROFILE.SAVE(p_profile_option_name,
251: p_profile_value,
252: level_name,