APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_FUNDS_ALL_VL

Line 2423: ,p_fund_rec IN OZF_FUNDS_ALL_VL%ROWTYPE,

2419: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2420: ,x_return_status OUT NOCOPY VARCHAR2
2421: ,x_msg_count OUT NOCOPY NUMBER
2422: ,x_msg_data OUT NOCOPY VARCHAR2
2423: ,p_fund_rec IN OZF_FUNDS_ALL_VL%ROWTYPE,
2424: x_new_fund_id OUT NOCOPY NUMBER
2425: )
2426: IS
2427:

Line 2437: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE := p_fund_rec;

2433: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
2434: l_msg_count NUMBER;
2435: l_msg_data VARCHAR2(10000);
2436:
2437: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE := p_fund_rec;
2438: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2439: l_start_date_active Date;
2440: l_end_date_active date;
2441: -- l_return_status Varchar2(30);

Line 2594: l_new_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2590:
2591: IS
2592: l_object_version NUMBER;
2593: l_new_user_status_id NUMBER;
2594: l_new_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2595: l_new_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2596: l_fund_rec OZF_Funds_PVT.fund_rec_type;
2597: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
2598: l_api_name CONSTANT VARCHAR2(30)

Line 2613: SELECT * FROM OZF_FUNDS_ALL_VL

2609: l_mode VARCHAR2(30);
2610: l_end_date DATE;
2611: -- get all the newly created budgets
2612: CURSOR c_get_new_funds IS
2613: SELECT * FROM OZF_FUNDS_ALL_VL
2614: WHERE PREV_FUND_ID IS NOT NULL
2615: AND TRANSFERED_FLAG IS NULL
2616: AND STATUS_CODE IN('ACTIVE','DRAFT');
2617:

Line 2621: FROM OZF_FUNDS_ALL_VL

2617:
2618: --- get end date for previous fund.
2619: CURSOR c_prec_fund (p_fund_id IN NUMBER) IS
2620: SELECT end_date_active,object_version_number
2621: FROM OZF_FUNDS_ALL_VL
2622: WHERE fund_id = p_fund_id;
2623:
2624: BEGIN
2625:

Line 2842: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2838: l_fund_id NUMBER := p_fund_id;
2839: l_hierarchy_flag VARCHAR2(30) := NVL(p_hierarchy_flag,'N');
2840: l_amount_flag VARCHAR2(30) := NVL(p_amount_flag,'N');
2841: -- to store the parent budget information
2842: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2843: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2844: -- to store the child budget informations
2845: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2846: l_child_fund_rec_type OZF_Funds_PVT.fund_rec_type;

Line 2845: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2841: -- to store the parent budget information
2842: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2843: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2844: -- to store the child budget informations
2845: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2846: l_child_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2847: l_start_date_active DATE;
2848: l_end_date_active DATE;
2849: l_parent_fund_id NUMBER;

Line 2865: SELECT * FROM ozf_funds_all_vl

2861: TYPE dyna_get_fund_id IS REF CURSOR;
2862: c_get_fund_id dyna_get_fund_id;
2863:
2864: CURSOR c_get_fund_details(p_fund_id IN NUMBER) IS
2865: SELECT * FROM ozf_funds_all_vl
2866: WHERE fund_id = p_fund_id
2867: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2868: WHERE prev_fund_id = p_fund_id);
2869:

Line 2872: SELECT * from ozf_funds_all_vl

2868: WHERE prev_fund_id = p_fund_id);
2869:
2870: -- Gets the child budgets details
2871: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS
2872: SELECT * from ozf_funds_all_vl
2873: WHERE fund_id = p_fund_id
2874: AND status_code = 'ACTIVE'
2875: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2876: WHERE prev_fund_id = p_fund_id);