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 109: DFLT_REFPARTNBR CZ_DB_SETTINGS.VALUE%TYPE;

105: nOrg_ID IN NUMBER,
106: nTop_ID IN NUMBER,
107: sExpl_type IN VARCHAR2)
108: IS
109: DFLT_REFPARTNBR CZ_DB_SETTINGS.VALUE%TYPE;
110: xERROR BOOLEAN :=FALSE;
111:
112: v_settings_id VARCHAR2(40);
113: v_section_name VARCHAR2(30);

Line 116: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS

112: v_settings_id VARCHAR2(40);
113: v_section_name VARCHAR2(30);
114:
115: CURSOR C_REF_PART_NBR IS
116: SELECT UPPER(VALUE) FROM CZ_DB_SETTINGS
117: WHERE UPPER(SECTION_NAME) = v_section_name
118: AND UPPER(SETTING_ID) = v_settings_id;
119:
120: TYPE tItemDesc IS TABLE OF cz_exv_items.item_desc%TYPE INDEX BY BINARY_INTEGER;

Line 717: FROM cz_db_settings

713:
714: BEGIN
715:
716: SELECT TO_NUMBER(value) INTO MemoryBulkSize
717: FROM cz_db_settings
718: WHERE LOWER(setting_id) = v_settings_id
719: AND LOWER(section_name) = v_section_name;
720:
721: EXCEPTION

Line 1415: INTO genStatisticsCz FROM CZ_DB_SETTINGS

1411: v_section_name := 'IMPORT';
1412:
1413: BEGIN
1414: 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')
1415: INTO genStatisticsCz FROM CZ_DB_SETTINGS
1416: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: genStatisticsCz := 0;

Line 1669: FROM cz_db_settings

1665:
1666: BEGIN
1667:
1668: SELECT TO_NUMBER(value) INTO MemoryBulkSize
1669: FROM cz_db_settings
1670: WHERE LOWER(setting_id) = v_settings_id
1671: AND LOWER(section_name) = v_section_name;
1672:
1673: EXCEPTION

Line 2610: sResolve CZ_DB_SETTINGS.VALUE%TYPE;

2606:
2607: xERROR BOOLEAN:=FALSE;
2608: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2609: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2610: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2611:
2612: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2613: tabValues tNumber;
2614:

Line 2656: SELECT VALUE INTO sResolve FROM CZ_DB_SETTINGS

2652: v_settings_id := 'ResolvePropertyDataType';
2653: v_section_name := 'ORAAPPS_INTEGRATE';
2654:
2655: BEGIN
2656: SELECT VALUE INTO sResolve FROM CZ_DB_SETTINGS
2657: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: sResolve:='NO';

Line 3440: sVersion CZ_DB_SETTINGS.VALUE%TYPE;

3436: xERROR BOOLEAN:=FALSE;
3437: nRunExploder PLS_INTEGER;
3438: cFound CHAR(1);
3439: dDateFormat VARCHAR2(40);
3440: sVersion CZ_DB_SETTINGS.VALUE%TYPE;
3441: server_id cz_servers.server_local_id%TYPE;
3442: nModelId NUMBER;
3443: topModelId NUMBER;
3444: genStatisticsBom PLS_INTEGER;

Line 3544: INTO importUnchangedChildModels FROM CZ_DB_SETTINGS

3540: v_section_name := 'IMPORT';
3541:
3542: BEGIN
3543: 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')
3544: INTO importUnchangedChildModels FROM CZ_DB_SETTINGS
3545: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3546: EXCEPTION
3547: WHEN OTHERS THEN
3548: importUnchangedChildModels := 1;

Line 3558: INTO genStatisticsBom FROM CZ_DB_SETTINGS

3554: v_section_name := 'IMPORT';
3555:
3556: BEGIN
3557: 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')
3558: INTO genStatisticsBom FROM CZ_DB_SETTINGS
3559: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3560: EXCEPTION
3561: WHEN OTHERS THEN
3562: genStatisticsBom := 0;

Line 3572: INTO genStatisticsCz FROM CZ_DB_SETTINGS

3568: v_section_name := 'IMPORT';
3569:
3570: BEGIN
3571: 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')
3572: INTO genStatisticsCz FROM CZ_DB_SETTINGS
3573: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3574: EXCEPTION
3575: WHEN OTHERS THEN
3576: genStatisticsCz := 0;

Line 3589: INTO allowDecimalOptionClass FROM CZ_DB_SETTINGS

3585: v_section_name := 'IMPORT';
3586:
3587: BEGIN
3588: 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)
3589: INTO allowDecimalOptionClass FROM CZ_DB_SETTINGS
3590: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3591: EXCEPTION
3592: WHEN OTHERS THEN
3593: allowDecimalOptionClass := 0;

Line 3618: INTO nRunExploder FROM CZ_DB_SETTINGS

3614: BEGIN
3615: SELECT DECODE(UPPER(value), 'YES', 1, 'Y', 1, '1', 1, 'TRUE', 1, 'T', 1,
3616: 'NO', 0, 'N', 0, '0', 0, 'FALSE', 0, 'F', 0,
3617: 0)
3618: INTO nRunExploder FROM CZ_DB_SETTINGS
3619: WHERE UPPER(SECTION_NAME) = v_section_name
3620: AND UPPER(SETTING_ID) = v_settings_id;
3621: EXCEPTION
3622: WHEN OTHERS THEN

Line 3630: SELECT VALUE INTO sVersion FROM CZ_DB_SETTINGS

3626: v_settings_id := 'BOM_REVISION';
3627: v_section_name := 'ORAAPPS_INTEGRATE';
3628:
3629: BEGIN
3630: SELECT VALUE INTO sVersion FROM CZ_DB_SETTINGS
3631: WHERE UPPER(SECTION_NAME) = v_section_name
3632: AND UPPER(SETTING_ID) = v_settings_id;
3633: EXCEPTION
3634: WHEN OTHERS THEN

Line 3647: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS

3643:
3644: v_settings_id := 'COMMITSIZE';
3645: v_section_name := 'IMPORT';
3646:
3647: SELECT VALUE INTO nCommit_size FROM CZ_DB_SETTINGS
3648: WHERE UPPER(SETTING_ID) = v_settings_id
3649: AND UPPER(SECTION_NAME) = v_section_name;
3650:
3651: v_settings_id := 'MAXIMUMERRORS';

Line 3654: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS

3650:
3651: v_settings_id := 'MAXIMUMERRORS';
3652: v_section_name := 'IMPORT';
3653:
3654: SELECT VALUE INTO nMax_err FROM CZ_DB_SETTINGS
3655: WHERE UPPER(SETTING_ID) = v_settings_id
3656: AND UPPER(SECTION_NAME) = v_section_name;
3657: EXCEPTION
3658: WHEN OTHERS THEN