APPS.PV_PEC_RULES_PVT dependencies on PV_PG_ENRL_CHANGE_RULES

Line 104: SELECT pv_pg_enrl_change_rules_s.NEXTVAL

100: l_enrl_change_rule_id_rev NUMBER;
101: l_value NUMBER;
102:
103: CURSOR c_id IS
104: SELECT pv_pg_enrl_change_rules_s.NEXTVAL
105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1

Line 109: FROM PV_PG_ENRL_CHANGE_RULES

105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1
109: FROM PV_PG_ENRL_CHANGE_RULES
110: WHERE enrl_change_rule_id = l_id;
111:
112: /*CURSOR c_program_id_exists (from_id IN NUMBER,to_id IN NUMBER) IS
113: SELECT 1

Line 114: FROM PV_PG_ENRL_CHANGE_RULES

110: WHERE enrl_change_rule_id = l_id;
111:
112: /*CURSOR c_program_id_exists (from_id IN NUMBER,to_id IN NUMBER) IS
113: SELECT 1
114: FROM PV_PG_ENRL_CHANGE_RULES
115: WHERE change_from_program_id = from_id
116: AND change_to_program_id = to_id
117: AND NVL(effective_to_date,sysdate) >= SYSDATE
118: AND change_direction_code = 'UPGRADE';

Line 122: FROM PV_PG_ENRL_CHANGE_RULES

118: AND change_direction_code = 'UPGRADE';
119: */
120: CURSOR c_program_id_exists (from_id IN NUMBER,to_id IN NUMBER,p_direction_code in VARCHAR2) IS
121: SELECT 1
122: FROM PV_PG_ENRL_CHANGE_RULES
123: WHERE change_from_program_id = from_id
124: AND change_to_program_id = to_id
125: AND NVL(effective_to_date,sysdate) >= SYSDATE
126: AND change_direction_code = p_direction_code;

Line 500: FROM PV_PG_ENRL_CHANGE_RULES

496:
497:
498: CURSOR c_get_pec_rules(enrl_change_rule_id NUMBER) IS
499: SELECT *
500: FROM PV_PG_ENRL_CHANGE_RULES
501: WHERE enrl_change_rule_id = p_pec_rules_rec.enrl_change_rule_id;
502: -- Hint: Developer need to provide Where clause
503:
504: CURSOR c_get_pec_rec_down(l_enrl_change_from_id_rev IN NUMBER, l_enrl_change_to_id_rev IN NUMBER ) IS

Line 506: FROM PV_PG_ENRL_CHANGE_RULES

502: -- Hint: Developer need to provide Where clause
503:
504: CURSOR c_get_pec_rec_down(l_enrl_change_from_id_rev IN NUMBER, l_enrl_change_to_id_rev IN NUMBER ) IS
505: SELECT *
506: FROM PV_PG_ENRL_CHANGE_RULES
507: WHERE change_from_program_id = l_enrl_change_from_id_rev
508: AND change_to_program_id = l_enrl_change_to_id_rev
509: AND effective_to_date is null
510: AND change_direction_code='DOWNGRADE';

Line 784: FROM PV_PG_ENRL_CHANGE_RULES

780: IS
781:
782: CURSOR c_get_pec_rec IS
783: SELECT *
784: FROM PV_PG_ENRL_CHANGE_RULES
785: WHERE enrl_change_rule_id = p_enrl_change_rule_id;
786:
787: CURSOR c_get_pec_rec_down(l_enrl_change_from_id_rev IN NUMBER, l_enrl_change_to_id_rev IN NUMBER ) IS
788: SELECT *

Line 789: FROM PV_PG_ENRL_CHANGE_RULES

785: WHERE enrl_change_rule_id = p_enrl_change_rule_id;
786:
787: CURSOR c_get_pec_rec_down(l_enrl_change_from_id_rev IN NUMBER, l_enrl_change_to_id_rev IN NUMBER ) IS
788: SELECT *
789: FROM PV_PG_ENRL_CHANGE_RULES
790: WHERE change_from_program_id = l_enrl_change_from_id_rev
791: AND change_to_program_id = l_enrl_change_to_id_rev
792: AND effective_to_date is null
793: AND change_direction_code='DOWNGRADE';

Line 1174: 'PV_PG_ENRL_CHANGE_RULES',

1170: IF p_validation_mode = JTF_PLSQL_API.g_create
1171: AND p_pec_rules_rec.enrl_change_rule_id IS NOT NULL
1172: THEN
1173: l_valid_flag := PVX_UTIlity_PVT.check_uniqueness(
1174: 'PV_PG_ENRL_CHANGE_RULES',
1175: ' enrl_change_rule_id = ''' || p_pec_rules_rec.enrl_change_rule_id ||''''
1176: );
1177: END IF;
1178:

Line 1435: FROM pv_pg_enrl_change_rules

1431: l_return_status VARCHAR2(1);
1432:
1433: CURSOR c_complete IS
1434: SELECT *
1435: FROM pv_pg_enrl_change_rules
1436: WHERE enrl_change_rule_id = p_pec_rules_rec.enrl_change_rule_id;
1437: l_pec_rules_rec c_complete%ROWTYPE;
1438: BEGIN
1439: x_complete_rec := p_pec_rules_rec;