APPS.OZF_FUNDS_PVT dependencies on OZF_FUNDS_ALL_VL

Line 460: 'ozf_funds_all_vl'

456: FETCH c_prog_fund_number INTO l_valid_flag;
457: CLOSE c_prog_fund_number; -- Bug Fix 3498826
458:
459: /*l_valid_flag := ams_utility_pvt.check_uniqueness(
460: 'ozf_funds_all_vl'
461: ,'fund_number = ''' || l_fund_rec.fund_number || '''');*/
462:
463: END LOOP;
464: -- by feliu on 11/10/03 to fix bug 3244033

Line 3623: 'ozf_funds_all_vl'

3619: -- check if this fund_id is unique.
3620: IF p_validation_mode = jtf_plsql_api.g_create
3621: AND p_fund_rec.fund_id IS NOT NULL THEN
3622: IF ozf_utility_pvt.check_uniqueness(
3623: 'ozf_funds_all_vl'
3624: ,'fund_id = ' || p_fund_rec.fund_id) =
3625: fnd_api.g_false THEN
3626: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3627: IF p_fund_rec.fund_type = 'QUOTA' THEN

Line 3645: 'ozf_funds_all_vl'

3641: -- update differently.
3642: IF p_validation_mode = jtf_plsql_api.g_create THEN
3643: /*l_valid_flag :=
3644: ozf_utility_pvt.check_uniqueness(
3645: 'ozf_funds_all_vl'
3646: ,'fund_number = ''' || p_fund_rec.fund_number || '''');*/
3647: OPEN c_prog_fund_number_create;
3648: FETCH c_prog_fund_number_create INTO l_valid_flag;
3649: CLOSE c_prog_fund_number_create;

Line 3653: 'ozf_funds_all_vl'

3649: CLOSE c_prog_fund_number_create;
3650: ELSE
3651: /* l_valid_flag :=
3652: ozf_utility_pvt.check_uniqueness(
3653: 'ozf_funds_all_vl'
3654: ,'fund_number = ''' ||
3655: p_fund_rec.fund_number ||
3656: ''' AND fund_id <> ' ||
3657: p_fund_rec.fund_id);*/

Line 3684: 'ozf_funds_all_vl'

3680: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
3681: IF p_validation_mode = jtf_plsql_api.g_create THEN
3682: l_valid_flag :=
3683: ozf_utility_pvt.check_uniqueness(
3684: 'ozf_funds_all_vl'
3685: ,'short_name = ''' || p_fund_rec.short_name || '''');
3686: ELSE
3687: l_valid_flag :=
3688: ozf_utility_pvt.check_uniqueness(

Line 3689: 'ozf_funds_all_vl'

3685: ,'short_name = ''' || p_fund_rec.short_name || '''');
3686: ELSE
3687: l_valid_flag :=
3688: ozf_utility_pvt.check_uniqueness(
3689: 'ozf_funds_all_vl'
3690: ,'short_name = ''' ||
3691: p_fund_rec.short_name ||
3692: ''' AND fund_id <> ' ||
3693: p_fund_rec.fund_id);

Line 4511: FROM ozf_funds_all_vl

4507: IS
4508: CURSOR c_fund
4509: IS
4510: SELECT *
4511: FROM ozf_funds_all_vl
4512: WHERE fund_id = p_fund_rec.fund_id;
4513:
4514: l_fund_rec c_fund%ROWTYPE;
4515: BEGIN

Line 5390: FROM ozf_funds_all_vl

5386: l_errmsg VARCHAR2(4000);
5387:
5388: CURSOR c_fund (p_fund_id IN NUMBER) IS
5389: SELECT *
5390: FROM ozf_funds_all_vl
5391: WHERE fund_id = p_fund_id
5392: ;
5393: CURSOR c_user_status_id (p_status_type IN VARCHAR2, p_status_code IN VARCHAR2) IS
5394: SELECT user_status_id