APPS.CZ_IMP_IM_KRS dependencies on CZ_DB_SETTINGS

Line 29: SELECT VALUE FROM CZ_DB_SETTINGS

25: v_settings_id VARCHAR2(40);
26: v_section_name VARCHAR2(30);
27:
28: CURSOR C_ITEM_TYPE_ID IS
29: SELECT VALUE FROM CZ_DB_SETTINGS
30: WHERE SECTION_NAME=v_section_name
31: AND SETTING_ID=v_settings_id;
32:
33: CURSOR C_ITEM_TYPE(nItemTypeId PLS_INTEGER) IS

Line 43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;

39: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;
40: x_onl_itemmaster_itemid_f BOOLEAN:=FALSE;
41: x_onl_default_itemtypeid_f BOOLEAN:=FALSE;
42: x_error BOOLEAN:=FALSE;
43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;

Line 100: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

96: v_settings_id := 'OracleSequenceIncr';
97: v_section_name := 'SCHEMA';
98:
99: BEGIN
100: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
101: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
102: EXCEPTION
103: WHEN OTHERS THEN
104: nAllocateBlock:=1;

Line 648: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

644: v_settings_id := 'OracleSequenceIncr';
645: v_section_name := 'SCHEMA';
646:
647: BEGIN
648: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
649: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
650: EXCEPTION
651: WHEN OTHERS THEN
652: nAllocateBlock:=1;

Line 1047: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

1043: v_settings_id := 'OracleSequenceIncr';
1044: v_section_name := 'SCHEMA';
1045:
1046: BEGIN
1047: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
1048: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: nAllocateBlock:=1;