APPS.CZ_IMP_PS_NODE dependencies on CZ_DB_SETTINGS

Line 96: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

92: v_settings_id := 'OracleSequenceIncr';
93: v_section_name := 'SCHEMA';
94:
95: BEGIN
96: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
97: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
98: EXCEPTION
99: WHEN OTHERS THEN
100: nAllocateBlock:=1;

Line 938: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

934: v_settings_id := 'OracleSequenceIncr';
935: v_section_name := 'SCHEMA';
936:
937: BEGIN
938: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
939: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
940: EXCEPTION
941: WHEN OTHERS THEN
942: nAllocateBlock:=1;

Line 952: INTO disableMultipleCopyImport FROM CZ_DB_SETTINGS

948: v_section_name := 'IMPORT';
949:
950: BEGIN
951: 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)
952: INTO disableMultipleCopyImport FROM CZ_DB_SETTINGS
953: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
954: EXCEPTION
955: WHEN OTHERS THEN
956: disableMultipleCopyImport := 0;

Line 2065: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;

2061:
2062: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
2063: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2064: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
2065: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
2066: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2067: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2068: --LA
2069: tmpOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;

Line 2126: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

2122: v_settings_id := 'OracleSequenceIncr';
2123: v_section_name := 'SCHEMA';
2124:
2125: BEGIN
2126: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
2127: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
2128: EXCEPTION
2129: WHEN OTHERS THEN
2130: nAllocateBlock:=1;

Line 2137: SELECT VALUE INTO sPsNodeName FROM CZ_DB_SETTINGS

2133: v_settings_id := 'PsNodeName';
2134: v_section_name := 'ORAAPPS_INTEGRATE';
2135:
2136: BEGIN
2137: SELECT VALUE INTO sPsNodeName FROM CZ_DB_SETTINGS
2138: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: NULL;

Line 3057: INTO genStatisticsCz FROM CZ_DB_SETTINGS

3053: v_section_name := 'IMPORT';
3054:
3055: BEGIN
3056: 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')
3057: INTO genStatisticsCz FROM CZ_DB_SETTINGS
3058: WHERE upper(SETTING_ID)=v_settings_id AND SECTION_NAME=v_section_name;
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: genStatisticsCz := 0;