APPS.AMS_CODE_DEFINITION_PVT dependencies on BIM_R_CODE_DEFINITIONS

Line 46: SELECT BIM_R_CODE_DEFINITIONS_s.NEXTVAL

42: l_dummy NUMBER;
43:
44:
45: CURSOR c_id IS
46: SELECT BIM_R_CODE_DEFINITIONS_s.NEXTVAL
47: FROM dual;
48:
49: CURSOR c_id_exists (l_id IN NUMBER) IS
50: SELECT 1

Line 51: FROM BIM_R_CODE_DEFINITIONS

47: FROM dual;
48:
49: CURSOR c_id_exists (l_id IN NUMBER) IS
50: SELECT 1
51: FROM BIM_R_CODE_DEFINITIONS
52: WHERE CODE_DEFINITION_ID = l_id
53: ;
54:
55: CURSOR c_col_name(l_colName IN VARCHAR2, l_obj_type IN VARCHAR2)IS

Line 57: FROM BIM_R_CODE_DEFINITIONS

53: ;
54:
55: CURSOR c_col_name(l_colName IN VARCHAR2, l_obj_type IN VARCHAR2)IS
56: SELECT count(*)
57: FROM BIM_R_CODE_DEFINITIONS
58: WHERE column_name = l_colName
59: AND column_name<>'Z'
60: AND object_type = l_obj_type
61: ;

Line 244: FROM bim_r_code_definitions

240: l_return_status VARCHAR2(1);
241:
242: CURSOR c_complete IS
243: SELECT *
244: FROM bim_r_code_definitions
245: WHERE code_definition_id = p_code_def_rec.code_definition_id;
246: l_code_def_rec c_complete%ROWTYPE;
247: BEGIN
248: x_complete_rec := p_code_def_rec;

Line 327: FROM BIM_R_CODE_DEFINITIONS

323: IS
324:
325: CURSOR c_get_code_definition(creation_date DATE) IS
326: SELECT *
327: FROM BIM_R_CODE_DEFINITIONS
328: WHERE code_definition_id = p_code_def_rec.code_definition_id;
329: -- Hint: Developer need to provide Where clause
330:
331: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Code_Definition';

Line 637: FROM BIM_R_CODE_DEFINITIONS

633: l_CODE_DEFINITION_ID NUMBER;
634:
635: CURSOR c_Code_Definition IS
636: SELECT CODE_DEFINITION_ID
637: FROM BIM_R_CODE_DEFINITIONS
638: WHERE CODE_DEFINITION_ID = p_CODE_DEFINITION_ID
639: AND object_version_number = p_object_version
640: FOR UPDATE NOWAIT;
641:

Line 744: 'BIM_R_CODE_DEFINITIONS',

740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'BIM_R_CODE_DEFINITIONS',
745: 'CODE_DEFINITION_ID = ''' || p_code_def_rec.CODE_DEFINITION_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 749: 'BIM_R_CODE_DEFINITIONS',

745: 'CODE_DEFINITION_ID = ''' || p_code_def_rec.CODE_DEFINITION_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
749: 'BIM_R_CODE_DEFINITIONS',
750: 'CODE_DEFINITION_ID = ''' || p_code_def_rec.CODE_DEFINITION_ID ||
751: ''' AND CODE_DEFINITION_ID <> ' || p_code_def_rec.CODE_DEFINITION_ID
752: );
753: END IF;