APPS.PV_PRGM_PTR_TYPES_PVT dependencies on PV_PROGRAM_PARTNER_TYPES

Line 57: SELECT PV_PROGRAM_PARTNER_TYPES_s.NEXTVAL

53: l_object_version_number NUMBER := 1;
54: l_uniqueness_check VARCHAR2(1);
55:
56: CURSOR c_prgm_ptr_types_id_seq IS
57: SELECT PV_PROGRAM_PARTNER_TYPES_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_prgm_ptr_types_id_seq_exists (l_id IN NUMBER) IS
61: SELECT 'X'

Line 62: FROM PV_PROGRAM_PARTNER_TYPES

58: FROM dual;
59:
60: CURSOR c_prgm_ptr_types_id_seq_exists (l_id IN NUMBER) IS
61: SELECT 'X'
62: FROM PV_PROGRAM_PARTNER_TYPES
63: WHERE PROGRAM_PARTNER_TYPES_ID = l_id;
64:
65: BEGIN
66: ---------------Initialize --------------------

Line 269: FROM PV_PROGRAM_PARTNER_TYPES

265:
266:
267: CURSOR c_get_pgm_tgt_ptr_typ(cv_program_partner_types_id NUMBER) IS
268: SELECT *
269: FROM PV_PROGRAM_PARTNER_TYPES
270: WHERE program_partner_types_id = cv_program_partner_types_id;
271:
272: l_api_name CONSTANT VARCHAR2(30) := 'Update_Prgm_Ptr_Type';
273: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 600: FROM PV_PROGRAM_PARTNER_TYPES

596: l_program_partner_types_id NUMBER;
597:
598: CURSOR c_Pgm_Tgt_Ptr_Typ IS
599: SELECT PROGRAM_PARTNER_TYPES_ID
600: FROM PV_PROGRAM_PARTNER_TYPES
601: WHERE PROGRAM_PARTNER_TYPES_ID = p_PROGRAM_PARTNER_TYPES_ID
602: AND object_version_number = p_object_version
603: FOR UPDATE NOWAIT;
604:

Line 722: 'PV_PROGRAM_PARTNER_TYPES'

718: x_return_status := FND_API.g_ret_sts_success;
719: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
720:
721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
722: 'PV_PROGRAM_PARTNER_TYPES'
723: ,'PROGRAM_PARTNER_TYPES_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID ||''''
724: );
725:
726: IF l_valid_flag = FND_API.g_false THEN

Line 742: 'PV_PROGRAM_PARTNER_TYPES'

738: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before PROGRAM_TYPE_ID check' );
739: END IF;
740:
741: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
742: 'PV_PROGRAM_PARTNER_TYPES'
743: ,'PROGRAM_TYPE_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID ||''' AND PARTNER_TYPE = ''' || p_prgm_ptr_types_rec.PARTNER_TYPE || ''''
744: );
745:
746: IF l_valid_flag = FND_API.g_false THEN

Line 1074: FROM PV_PROGRAM_PARTNER_TYPES

1070: IS
1071:
1072: CURSOR c_complete IS
1073: SELECT *
1074: FROM PV_PROGRAM_PARTNER_TYPES
1075: WHERE program_partner_types_id = p_prgm_ptr_types_rec.program_partner_types_id;
1076:
1077: l_prgm_ptr_types_rec c_complete%ROWTYPE;
1078: