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.CZ_ORAAPPS_INTEGRATE dependencies on CZ_DB_SETTINGS

Line 736: value_set=>'CZ_DB_SETTINGS_SECTION_NAME',

732: application=>application_name,
733: sequence=>1,
734: parameter=>'SECTION_NAME',
735: description=>'SECTION NAME',
736: value_set=>'CZ_DB_SETTINGS_SECTION_NAME',
737: display_size=>20,
738: description_size=>20,
739: concatenated_description_size=>50,
740: prompt=>'SECTION_NAME');

Line 746: value_set=>'CZ_DB_SETTINGS_SETTING_ID',

742: application=>application_name,
743: sequence=>2,
744: parameter=>'SETTING_ID',
745: description=>'SETTING_ID',
746: value_set=>'CZ_DB_SETTINGS_SETTING_ID',
747: display_size=>20,
748: description_size=>20,
749: concatenated_description_size=>50,
750: prompt=>'SETTING_ID');

Line 766: value_set=>'CZ_DB_SETTINGS_TYPE',

762: application=>application_name,
763: sequence=>4,
764: parameter=>'TYPE',
765: description=>'TYPE',
766: value_set=>'CZ_DB_SETTINGS_TYPE',
767: display_size=>20,
768: description_size=>20,
769: concatenated_description_size=>50,
770: prompt=>'TYPE');

Line 1214: stmt:='SELECT setting_id,value from '||var_schema||'CZ_DB_SETTINGS WHERE section_name like '''||section_name||

1210: ELSE
1211: var_schema:=cz_schema||'.';
1212: END IF;
1213: cur:=dbms_sql.open_cursor;
1214: stmt:='SELECT setting_id,value from '||var_schema||'CZ_DB_SETTINGS WHERE section_name like '''||section_name||
1215: ''' and setting_id like '''||setting_id||''' ';
1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);

Line 1254: SELECT SECTION_NAME,SETTING_ID,VALUE,DESC_TEXT FROM CZ_DB_SETTINGS

1250: LIKE_SectionName IN VARCHAR2 , -- DEFAULT '%',
1251: LIKE_SettingID IN VARCHAR2 -- DEFAULT '%'
1252: ) IS
1253: CURSOR C_GETSET IS
1254: SELECT SECTION_NAME,SETTING_ID,VALUE,DESC_TEXT FROM CZ_DB_SETTINGS
1255: WHERE SECTION_NAME LIKE LIKE_SectionName AND SETTING_ID LIKE LIKE_SettingID;
1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;
1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;
1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;

Line 1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;

1252: ) IS
1253: CURSOR C_GETSET IS
1254: SELECT SECTION_NAME,SETTING_ID,VALUE,DESC_TEXT FROM CZ_DB_SETTINGS
1255: WHERE SECTION_NAME LIKE LIKE_SectionName AND SETTING_ID LIKE LIKE_SettingID;
1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;
1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;
1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;
1259: slDescription CZ_DB_SETTINGS.DESC_TEXT%TYPE;
1260: BEGIN

Line 1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;

1253: CURSOR C_GETSET IS
1254: SELECT SECTION_NAME,SETTING_ID,VALUE,DESC_TEXT FROM CZ_DB_SETTINGS
1255: WHERE SECTION_NAME LIKE LIKE_SectionName AND SETTING_ID LIKE LIKE_SettingID;
1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;
1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;
1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;
1259: slDescription CZ_DB_SETTINGS.DESC_TEXT%TYPE;
1260: BEGIN
1261: errbuf:='';

Line 1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;

1254: SELECT SECTION_NAME,SETTING_ID,VALUE,DESC_TEXT FROM CZ_DB_SETTINGS
1255: WHERE SECTION_NAME LIKE LIKE_SectionName AND SETTING_ID LIKE LIKE_SettingID;
1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;
1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;
1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;
1259: slDescription CZ_DB_SETTINGS.DESC_TEXT%TYPE;
1260: BEGIN
1261: errbuf:='';
1262: retcode:=0;

Line 1259: slDescription CZ_DB_SETTINGS.DESC_TEXT%TYPE;

1255: WHERE SECTION_NAME LIKE LIKE_SectionName AND SETTING_ID LIKE LIKE_SettingID;
1256: slSectionName CZ_DB_SETTINGS.SECTION_NAME%TYPE;
1257: slSettingID CZ_DB_SETTINGS.SETTING_ID%TYPE;
1258: slValue CZ_DB_SETTINGS.VALUE%TYPE;
1259: slDescription CZ_DB_SETTINGS.DESC_TEXT%TYPE;
1260: BEGIN
1261: errbuf:='';
1262: retcode:=0;
1263: OPEN C_GETSET;

Line 1291: SELECT 'X' FROM cz_db_settings

1287: sVALUE IN VARCHAR2,
1288: sTYPE IN VARCHAR2 , -- DEFAULT '4',
1289: sDESCRIPTION IN VARCHAR2 DEFAULT NULL) IS
1290: CURSOR c1 IS
1291: SELECT 'X' FROM cz_db_settings
1292: WHERE section_name=section_Name AND
1293: setting_id=sSetting_Id;
1294: var1 varchar2(1);
1295: BEGIN

Line 1301: UPDATE cz_db_settings SET value=sValue WHERE section_name=sSection_Name AND setting_id=sSetting_Id;

1297: retcode:=0;
1298: OPEN c1;
1299: FETCH c1 INTO var1;
1300: IF c1%found THEN
1301: UPDATE cz_db_settings SET value=sValue WHERE section_name=sSection_Name AND setting_id=sSetting_Id;
1302: ELSE
1303: INSERT INTO cz_db_settings(setting_id,section_name,data_type,value,desc_text)
1304: VALUES(sSetting_Id,sSection_Name,sType,sValue,sDESCRIPTION);
1305: END IF;

Line 1303: INSERT INTO cz_db_settings(setting_id,section_name,data_type,value,desc_text)

1299: FETCH c1 INTO var1;
1300: IF c1%found THEN
1301: UPDATE cz_db_settings SET value=sValue WHERE section_name=sSection_Name AND setting_id=sSetting_Id;
1302: ELSE
1303: INSERT INTO cz_db_settings(setting_id,section_name,data_type,value,desc_text)
1304: VALUES(sSetting_Id,sSection_Name,sType,sValue,sDESCRIPTION);
1305: END IF;
1306: CLOSE c1;
1307: COMMIT;

Line 1511: INTO settingVal FROM cz_db_settings

1507:
1508: SELECT DECODE(UPPER(value), '1', 1, 'ON', 1, 'Y', 1, 'YES', 1,'TRUE', 1, 'ENABLE', 1,
1509: '0', 0, 'OFF', 0, 'N', 0, 'NO', 0,'FALSE', 0, 'DISABLE', 0,
1510: 0) --default value
1511: INTO settingVal FROM cz_db_settings
1512: WHERE UPPER(section_name) = 'IMPORT'
1513: AND UPPER(setting_id) = 'USELOCALTABLEINEXTRACTIONVIEWS';
1514:
1515: EXCEPTION