APPS.CZ_IMP_IM_KRS dependencies on CZ_DB_SETTINGS

Line 27: SELECT VALUE FROM CZ_DB_SETTINGS

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

Line 41: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;

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

Line 75: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

71: v_settings_id := 'OracleSequenceIncr';
72: v_section_name := 'SCHEMA';
73:
74: BEGIN
75: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
76: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
77: EXCEPTION
78: WHEN OTHERS THEN
79: nAllocateBlock:=1;

Line 564: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

560: v_settings_id := 'OracleSequenceIncr';
561: v_section_name := 'SCHEMA';
562:
563: BEGIN
564: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
565: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
566: EXCEPTION
567: WHEN OTHERS THEN
568: nAllocateBlock:=1;

Line 920: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS

916: v_settings_id := 'OracleSequenceIncr';
917: v_section_name := 'SCHEMA';
918:
919: BEGIN
920: SELECT VALUE INTO nAllocateBlock FROM CZ_DB_SETTINGS
921: WHERE SETTING_ID=v_settings_id AND SECTION_NAME=v_section_name;
922: EXCEPTION
923: WHEN OTHERS THEN
924: nAllocateBlock:=1;