APPS.PV_GE_NOTIF_RULES_PVT dependencies on PV_GE_NOTIF_RULES_B

Line 103: SELECT pv_ge_notif_rules_b_s.NEXTVAL

99: l_ge_notif_rules_rec ge_notif_rules_rec_type := p_ge_notif_rules_rec;
100: --anubhav added ends
101:
102: CURSOR c_id IS
103: SELECT pv_ge_notif_rules_b_s.NEXTVAL
104: FROM dual;
105:
106: CURSOR c_id_exists (l_id IN NUMBER) IS
107: SELECT 1

Line 108: FROM PV_GE_NOTIF_RULES_B

104: FROM dual;
105:
106: CURSOR c_id_exists (l_id IN NUMBER) IS
107: SELECT 1
108: FROM PV_GE_NOTIF_RULES_B
109: WHERE notif_rule_id = l_id;
110: BEGIN
111: -- Standard Start of API savepoint
112: SAVEPOINT create_ge_notif_rules_pvt;

Line 352: FROM pv_ge_notif_rules_b

348: CURSOR c_get_notif_rules_rec (cv_program_id IN NUMBER) IS
349: SELECT wf_item_type_code, notif_type_code, active_flag, repeat_freq_unit, repeat_freq_value,
350: send_notif_before_unit, send_notif_before_value, send_notif_after_unit, send_notif_after_value,
351: repeat_until_unit, repeat_until_value
352: FROM pv_ge_notif_rules_b
353: WHERE arc_notif_for_entity_code = 'PRGM'
354: AND notif_for_entity_id = cv_program_id
355: order by notif_rule_id;
356:

Line 359: FROM pv_ge_notif_rules_b b, pv_ge_notif_rules_tl tl

355: order by notif_rule_id;
356:
357: CURSOR c_get_notif_rules_tl_rec (cv_program_id IN NUMBER) IS
358: SELECT tl.notif_rule_id, notif_name, notif_content, notif_desc, language, source_lang
359: FROM pv_ge_notif_rules_b b, pv_ge_notif_rules_tl tl
360: WHERE arc_notif_for_entity_code = 'PRGM'
361: and b.notif_rule_id = tl.notif_rule_id
362: AND notif_for_entity_id = cv_program_id
363: order by tl.notif_rule_id;

Line 367: FROM pv_ge_notif_rules_b

363: order by tl.notif_rule_id;
364:
365: CURSOR c_get_notif_rules_id (cv_program_id IN NUMBER) IS
366: SELECT NOTIF_RULE_ID
367: FROM pv_ge_notif_rules_b
368: WHERE arc_notif_for_entity_code = 'PRGM'
369: AND notif_for_entity_id = cv_program_id;
370:
371: l_notif_rule_id NUMBER;

Line 455: update pv_ge_notif_rules_b

451: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
452: END IF;
453:
454: forall i in 1..wf_item_type_code_array.count
455: update pv_ge_notif_rules_b
456: set wf_item_type_code = wf_item_type_code_array(i),
457: notif_type_code = notif_type_code_array(i),
458: active_flag = active_flag_array(i),
459: repeat_freq_unit = repeat_freq_unit_array(i),

Line 618: FROM PV_GE_NOTIF_RULES_B

614:
615:
616: CURSOR c_get_ge_notif_rules(notif_rule_id NUMBER) IS
617: SELECT *
618: FROM PV_GE_NOTIF_RULES_B
619: WHERE notif_rule_id = p_ge_notif_rules_rec.notif_rule_id;
620: -- Hint: Developer need to provide Where clause
621:
622:

Line 1139: 'pv_ge_notif_rules_b',

1135: IF p_validation_mode = JTF_PLSQL_API.g_create
1136: AND p_ge_notif_rules_rec.notif_rule_id IS NOT NULL
1137: THEN
1138: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1139: 'pv_ge_notif_rules_b',
1140: 'notif_rule_id = ''' || p_ge_notif_rules_rec.notif_rule_id ||''''
1141: );
1142: END IF;
1143:

Line 1334: FROM pv_ge_notif_rules_b

1330: l_return_status VARCHAR2(1);
1331:
1332: CURSOR c_complete IS
1333: SELECT *
1334: FROM pv_ge_notif_rules_b
1335: WHERE notif_rule_id = p_ge_notif_rules_rec.notif_rule_id;
1336: l_ge_notif_rules_rec c_complete%ROWTYPE;
1337: BEGIN
1338: x_complete_rec := p_ge_notif_rules_rec;