APPS.OZF_FUNDS_PVT dependencies on OZF_FUNDS_ALL_VL

Line 452: 'ozf_funds_all_vl'

448: FETCH c_prog_fund_number INTO l_valid_flag;
449: CLOSE c_prog_fund_number; -- Bug Fix 3498826
450:
451: /*l_valid_flag := ams_utility_pvt.check_uniqueness(
452: 'ozf_funds_all_vl'
453: ,'fund_number = ''' || l_fund_rec.fund_number || '''');*/
454:
455: END LOOP;
456: -- by feliu on 11/10/03 to fix bug 3244033

Line 3224: 'ozf_funds_all_vl'

3220: -- check if this fund_id is unique.
3221: IF p_validation_mode = jtf_plsql_api.g_create
3222: AND p_fund_rec.fund_id IS NOT NULL THEN
3223: IF ozf_utility_pvt.check_uniqueness(
3224: 'ozf_funds_all_vl'
3225: ,'fund_id = ' || p_fund_rec.fund_id) =
3226: fnd_api.g_false THEN
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3228: IF p_fund_rec.fund_type = 'QUOTA' THEN

Line 3246: 'ozf_funds_all_vl'

3242: -- update differently.
3243: IF p_validation_mode = jtf_plsql_api.g_create THEN
3244: /*l_valid_flag :=
3245: ozf_utility_pvt.check_uniqueness(
3246: 'ozf_funds_all_vl'
3247: ,'fund_number = ''' || p_fund_rec.fund_number || '''');*/
3248: OPEN c_prog_fund_number_create;
3249: FETCH c_prog_fund_number_create INTO l_valid_flag;
3250: CLOSE c_prog_fund_number_create;

Line 3254: 'ozf_funds_all_vl'

3250: CLOSE c_prog_fund_number_create;
3251: ELSE
3252: /* l_valid_flag :=
3253: ozf_utility_pvt.check_uniqueness(
3254: 'ozf_funds_all_vl'
3255: ,'fund_number = ''' ||
3256: p_fund_rec.fund_number ||
3257: ''' AND fund_id <> ' ||
3258: p_fund_rec.fund_id);*/

Line 3285: 'ozf_funds_all_vl'

3281: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
3282: IF p_validation_mode = jtf_plsql_api.g_create THEN
3283: l_valid_flag :=
3284: ozf_utility_pvt.check_uniqueness(
3285: 'ozf_funds_all_vl'
3286: ,'short_name = ''' || p_fund_rec.short_name || '''');
3287: ELSE
3288: l_valid_flag :=
3289: ozf_utility_pvt.check_uniqueness(

Line 3290: 'ozf_funds_all_vl'

3286: ,'short_name = ''' || p_fund_rec.short_name || '''');
3287: ELSE
3288: l_valid_flag :=
3289: ozf_utility_pvt.check_uniqueness(
3290: 'ozf_funds_all_vl'
3291: ,'short_name = ''' ||
3292: p_fund_rec.short_name ||
3293: ''' AND fund_id <> ' ||
3294: p_fund_rec.fund_id);

Line 4109: FROM ozf_funds_all_vl

4105: IS
4106: CURSOR c_fund
4107: IS
4108: SELECT *
4109: FROM ozf_funds_all_vl
4110: WHERE fund_id = p_fund_rec.fund_id;
4111:
4112: l_fund_rec c_fund%ROWTYPE;
4113: BEGIN

Line 4988: FROM ozf_funds_all_vl

4984: l_errmsg VARCHAR2(4000);
4985:
4986: CURSOR c_fund (p_fund_id IN NUMBER) IS
4987: SELECT *
4988: FROM ozf_funds_all_vl
4989: WHERE fund_id = p_fund_id
4990: ;
4991: CURSOR c_user_status_id (p_status_type IN VARCHAR2, p_status_code IN VARCHAR2) IS
4992: SELECT user_status_id