[Home] [Help]
48: l_api_version_number CONSTANT NUMBER := 1.0;
49:
50: CURSOR lc_referral_info (pc_referral_id NUMBER) IS
51: SELECT partner_id ,benefit_id,benefit_type_code
52: FROM pv_referrals_b
53: WHERE referral_id = pc_referral_id;
54:
55: CURSOR lc_get_approver_name (pc_user_id NUMBER) IS
56: SELECT source_name FROM jtf_rs_resource_extns WHERE user_id = pc_user_id;
171: l_log_params_tbl(1).param_value := p_country_code;
172: l_log_params_tbl(2).param_name := 'APPROVER';
173: l_log_params_tbl(2).param_value := l_approver_name;
174:
175: update pv_referrals_b set customer_country = p_country_code where referral_id = p_referral_id;
176:
177: PVX_Utility_PVT.create_history_log(
178: p_arc_history_for_entity_code => p_approval_entity,
179: p_history_for_entity_id => p_referral_id,
504: cursor lc_get_approver_details (pc_user_id number) is
505: select decode(category, 'EMPLOYEE', source_id, null), category, source_name, user_name from jtf_rs_resource_extns where user_id = pc_user_id;
506:
507: cursor lc_return_reason IS
508: select return_reason_code from pv_referrals_b
509: where referral_id = p_referral_id;
510:
511: /**
512: * In case of referral return the note added by the user on the Notes
707: END IF;
708:
709: END IF;
710:
711: FOR x IN (SELECT partner_id FROM pv_referrals_b WHERE referral_id = p_referral_id) LOOP
712: l_partner_id := x.partner_id;
713: END LOOP;
714:
715: -- Bug fix for bug 3495565. If the current approver gets removed from the
1170: CLOSE lc_lock_approvals;
1171:
1172: IF x_approval_done <> 'Y' THEN
1173: -- Send Notification
1174: FOR x IN (SELECT partner_id ,benefit_id FROM pv_referrals_b WHERE referral_id = p_referral_id) LOOP
1175: l_benefit_id := x.benefit_id;
1176: l_partner_id := x.partner_id;
1177: END LOOP;
1178: