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_IMP_SINGLE dependencies on CZ_DB_SETTINGS

Line 131: DFLT_REFPARTNBR CZ_DB_SETTINGS.VALUE%TYPE;

127: nOrg_ID IN NUMBER,
128: nTop_ID IN NUMBER,
129: sExpl_type IN VARCHAR2)
130: IS
131: DFLT_REFPARTNBR CZ_DB_SETTINGS.VALUE%TYPE;
132: xERROR BOOLEAN :=FALSE;
133:
134: v_settings_id VARCHAR2(40);
135: v_section_name VARCHAR2(30);

Line 138: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS

134: v_settings_id VARCHAR2(40);
135: v_section_name VARCHAR2(30);
136:
137: CURSOR C_REF_PART_NBR IS
138: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS
139: WHERE UPPER(SECTION_NAME) = v_section_name
140: AND UPPER(SETTING_ID) = v_settings_id;
141:
142: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;

Line 744: FROM cz_db_settings

740:
741: BEGIN
742:
743: SELECT TO_NUMBER(value) INTO MemoryBulkSize
744: FROM cz_db_settings
745: WHERE LOWER(setting_id) = v_settings_id
746: AND LOWER(section_name) = v_section_name;
747:
748: EXCEPTION

Line 1445: INTO genStatisticsCz FROM CZ_DB_SETTINGS

1441: v_section_name := 'IMPORT';
1442:
1443: BEGIN
1444: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1','0','0','YES','1','NO','0','Y','1','N','0','0')
1445: INTO genStatisticsCz FROM CZ_DB_SETTINGS
1446: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: genStatisticsCz := 0;

Line 1463: INTO v_batchSize FROM CZ_DB_SETTINGS

1459: v_section_name := 'SCHEMA';
1460:
1461: BEGIN
1462: SELECT VALUE
1463: INTO v_batchSize FROM CZ_DB_SETTINGS
1464: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: v_batchSize := 5000;

Line 1731: FROM cz_db_settings

1727:
1728: BEGIN
1729:
1730: SELECT TO_NUMBER(value) INTO MemoryBulkSize
1731: FROM cz_db_settings
1732: WHERE LOWER(setting_id) = v_settings_id
1733: AND LOWER(section_name) = v_section_name;
1734:
1735: EXCEPTION

Line 2680: sResolve CZ_DB_SETTINGS.VALUE%TYPE;

2676:
2677: xERROR BOOLEAN:=FALSE;
2678: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2679: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2680: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2681:
2682: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2683: tabValues tNumber;
2684:

Line 2726: SELECT VALUE INTO sResolve FROM CZ_DB_SETTINGS

2722: v_settings_id := 'ResolvePropertyDataType';
2723: v_section_name := 'ORAAPPS_INTEGRATE';
2724:
2725: BEGIN
2726: SELECT VALUE INTO sResolve FROM CZ_DB_SETTINGS
2727: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
2728: EXCEPTION
2729: WHEN OTHERS THEN
2730: sResolve:='NO';

Line 3747: sVersion CZ_DB_SETTINGS.VALUE%TYPE;

3743: xERROR BOOLEAN:=FALSE;
3744: nRunExploder PLS_INTEGER;
3745: cFound CHAR(1);
3746: dDateFormat VARCHAR2(40);
3747: sVersion CZ_DB_SETTINGS.VALUE%TYPE;
3748: server_id cz_servers.server_local_id%TYPE;
3749: nModelId NUMBER;
3750: topModelId NUMBER;
3751: genStatisticsBom PLS_INTEGER;

Line 3857: INTO importUnchangedChildModels FROM CZ_DB_SETTINGS

3853: v_section_name := 'IMPORT';
3854:
3855: BEGIN
3856: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1','0','0','YES','1','NO','0','Y','1','N','0','1')
3857: INTO importUnchangedChildModels FROM CZ_DB_SETTINGS
3858: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3859: EXCEPTION
3860: WHEN OTHERS THEN
3861: importUnchangedChildModels := 1;

Line 3871: INTO genStatisticsBom FROM CZ_DB_SETTINGS

3867: v_section_name := 'IMPORT';
3868:
3869: BEGIN
3870: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1','0','0','YES','1','NO','0','Y','1','N','0','0')
3871: INTO genStatisticsBom FROM CZ_DB_SETTINGS
3872: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3873: EXCEPTION
3874: WHEN OTHERS THEN
3875: genStatisticsBom := 0;

Line 3885: INTO genStatisticsCz FROM CZ_DB_SETTINGS

3881: v_section_name := 'IMPORT';
3882:
3883: BEGIN
3884: SELECT decode(upper(VALUE),'TRUE','1','FALSE','0','T','1','F','0','1','1','0','0','YES','1','NO','0','Y','1','N','0','0')
3885: INTO genStatisticsCz FROM CZ_DB_SETTINGS
3886: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3887: EXCEPTION
3888: WHEN OTHERS THEN
3889: genStatisticsCz := 0;

Line 3902: INTO allowDecimalOptionClass FROM CZ_DB_SETTINGS

3898: v_section_name := 'IMPORT';
3899:
3900: BEGIN
3901: SELECT decode(upper(VALUE),'TRUE',1,'FALSE',0,'T',1,'F',0,'1',1,'0',0,'YES',1,'NO',0,'Y',1,'N',0,0)
3902: INTO allowDecimalOptionClass FROM CZ_DB_SETTINGS
3903: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3904: EXCEPTION
3905: WHEN OTHERS THEN
3906: allowDecimalOptionClass := 0;

Line 3931: INTO nRunExploder FROM CZ_DB_SETTINGS

3927: BEGIN
3928: SELECT DECODE(UPPER(value), 'YES', 1, 'Y', 1, '1', 1, 'TRUE', 1, 'T', 1,
3929: 'NO', 0, 'N', 0, '0', 0, 'FALSE', 0, 'F', 0,
3930: 0)
3931: INTO nRunExploder FROM CZ_DB_SETTINGS
3932: WHERE UPPER(SECTION_NAME) = v_section_name
3933: AND UPPER(SETTING_ID) = v_settings_id;
3934: EXCEPTION
3935: WHEN OTHERS THEN

Line 3943: SELECT VALUE INTO sVersion FROM CZ_DB_SETTINGS

3939: v_settings_id := 'BOM_REVISION';
3940: v_section_name := 'ORAAPPS_INTEGRATE';
3941:
3942: BEGIN
3943: SELECT VALUE INTO sVersion FROM CZ_DB_SETTINGS
3944: WHERE UPPER(SECTION_NAME) = v_section_name
3945: AND UPPER(SETTING_ID) = v_settings_id;
3946: EXCEPTION
3947: WHEN OTHERS THEN

Line 3960: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS

3956:
3957: v_settings_id := 'COMMITSIZE';
3958: v_section_name := 'IMPORT';
3959:
3960: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS
3961: WHERE UPPER(SETTING_ID) = v_settings_id
3962: AND UPPER(SECTION_NAME) = v_section_name;
3963:
3964: v_settings_id := 'MAXIMUMERRORS';

Line 3967: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS

3963:
3964: v_settings_id := 'MAXIMUMERRORS';
3965: v_section_name := 'IMPORT';
3966:
3967: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS
3968: WHERE UPPER(SETTING_ID) = v_settings_id
3969: AND UPPER(SECTION_NAME) = v_section_name;
3970: EXCEPTION
3971: WHEN OTHERS THEN

Line 3981: INTO disableMultipleCopyImport FROM CZ_DB_SETTINGS

3977: v_section_name := 'IMPORT';
3978:
3979: BEGIN
3980: SELECT decode(upper(VALUE),'TRUE',1,'FALSE',0,'T',1,'F',0,'1',1,'0',0,'YES',1,'NO',0,'Y',1,'N',0,0)
3981: INTO disableMultipleCopyImport FROM CZ_DB_SETTINGS
3982: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3983: EXCEPTION
3984: WHEN OTHERS THEN
3985: disableMultipleCopyImport := 0;