APPS.CZ_IMP_PS_NODE dependencies on CZ_DB_SETTINGS

Line 82: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

78: v_settings_id := 'OracleSequenceIncr';
79: v_section_name := 'SCHEMA';
80:
81: BEGIN
82: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
83: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
84: EXCEPTION
85: WHEN OTHERS THEN
86: nAllocateBlock:=1;

Line 794: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

790: v_settings_id := 'OracleSequenceIncr';
791: v_section_name := 'SCHEMA';
792:
793: BEGIN
794: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
795: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
796: EXCEPTION
797: WHEN OTHERS THEN
798: nAllocateBlock:=1;

Line 1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;

1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;

Line 1805: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

1801: v_settings_id := 'OracleSequenceIncr';
1802: v_section_name := 'SCHEMA';
1803:
1804: BEGIN
1805: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
1806: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: nAllocateBlock:=1;

Line 1816: SELECT VALUE INTO sPsNodeName FROM CZ_DB_SETTINGS

1812: v_settings_id := 'PsNodeName';
1813: v_section_name := 'ORAAPPS_INTEGRATE';
1814:
1815: BEGIN
1816: SELECT VALUE INTO sPsNodeName FROM CZ_DB_SETTINGS
1817: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: NULL;