APPS.PV_PARTNER_PGM_TYPE_PVT dependencies on PV_PARTNER_PROGRAM_TYPE_B

Line 72: -- Cursor to get the sequence for pv_partner_program_type_b

68:
69: l_object_version_number NUMBER := 1;
70: l_uniqueness_check VARCHAR2(1);
71:
72: -- Cursor to get the sequence for pv_partner_program_type_b
73: CURSOR c_partner_prgm_type_id_seq IS
74: SELECT PV_PARTNER_PROGRAM_TYPE_B_S.NEXTVAL
75: FROM dual;
76:

Line 74: SELECT PV_PARTNER_PROGRAM_TYPE_B_S.NEXTVAL

70: l_uniqueness_check VARCHAR2(1);
71:
72: -- Cursor to get the sequence for pv_partner_program_type_b
73: CURSOR c_partner_prgm_type_id_seq IS
74: SELECT PV_PARTNER_PROGRAM_TYPE_B_S.NEXTVAL
75: FROM dual;
76:
77: -- Cursor to validate the uniqueness
78: CURSOR c_ptr_prgm_type_id_seq_exists (l_id IN NUMBER) IS

Line 80: FROM PV_PARTNER_PROGRAM_TYPE_B

76:
77: -- Cursor to validate the uniqueness
78: CURSOR c_ptr_prgm_type_id_seq_exists (l_id IN NUMBER) IS
79: SELECT 'X'
80: FROM PV_PARTNER_PROGRAM_TYPE_B
81: WHERE PROGRAM_TYPE_ID = l_id;
82:
83: BEGIN
84: ---------------Initialize --------------------

Line 311: FROM PV_PARTNER_PROGRAM_TYPE_B

307: IS
308:
309: CURSOR c_get_partner_pgm_type(cv_PROGRAM_TYPE_ID NUMBER) IS
310: SELECT *
311: FROM PV_PARTNER_PROGRAM_TYPE_B
312: WHERE PROGRAM_TYPE_ID = cv_PROGRAM_TYPE_ID;
313:
314: l_api_name CONSTANT VARCHAR2(30) := 'Update_Partner_Pgm_Type';
315: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.'|| L_API_NAME;

Line 526: FROM PV_PARTNER_PROGRAM_TYPE_B

522: IS
523:
524: CURSOR c_get_ptr_prgm_type_rec(cv_PROGRAM_TYPE_ID NUMBER) IS
525: SELECT *
526: FROM PV_PARTNER_PROGRAM_TYPE_B
527: WHERE PROGRAM_TYPE_ID = cv_PROGRAM_TYPE_ID;
528:
529: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Partner_Pgm_Type';
530: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 730: FROM PV_PARTNER_PROGRAM_TYPE_B

726: l_PROGRAM_TYPE_ID NUMBER;
727:
728: CURSOR c_Partner_Pgm_Type IS
729: SELECT PROGRAM_TYPE_ID
730: FROM PV_PARTNER_PROGRAM_TYPE_B
731: WHERE PROGRAM_TYPE_ID = px_PROGRAM_TYPE_ID
732: AND object_version_number = p_object_version
733: FOR UPDATE NOWAIT;
734:

Line 849: 'PV_PARTNER_PROGRAM_TYPE_B',

845: x_return_status := FND_API.g_ret_sts_success;
846: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
847:
848: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
849: 'PV_PARTNER_PROGRAM_TYPE_B',
850: 'PROGRAM_TYPE_ID = ''' || p_ptr_prgm_type_rec.PROGRAM_TYPE_ID ||''''
851: );
852: -- Debug message
853: IF (PV_DEBUG_HIGH_ON) THEN