APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_FUNDS_ALL_VL

Line 2471: ,p_fund_rec IN OZF_FUNDS_ALL_VL%ROWTYPE,

2467: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2468: ,x_return_status OUT NOCOPY VARCHAR2
2469: ,x_msg_count OUT NOCOPY NUMBER
2470: ,x_msg_data OUT NOCOPY VARCHAR2
2471: ,p_fund_rec IN OZF_FUNDS_ALL_VL%ROWTYPE,
2472: x_new_fund_id OUT NOCOPY NUMBER
2473: )
2474: IS
2475:

Line 2485: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE := p_fund_rec;

2481: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
2482: l_msg_count NUMBER;
2483: l_msg_data VARCHAR2(10000);
2484:
2485: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE := p_fund_rec;
2486: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2487: l_start_date_active Date;
2488: l_end_date_active date;
2489: -- l_return_status Varchar2(30);

Line 2642: l_new_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2638:
2639: IS
2640: l_object_version NUMBER;
2641: l_new_user_status_id NUMBER;
2642: l_new_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2643: l_new_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2644: l_fund_rec OZF_Funds_PVT.fund_rec_type;
2645: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
2646: l_api_name CONSTANT VARCHAR2(30)

Line 2661: SELECT * FROM OZF_FUNDS_ALL_VL

2657: l_mode VARCHAR2(30);
2658: l_end_date DATE;
2659: -- get all the newly created budgets
2660: CURSOR c_get_new_funds IS
2661: SELECT * FROM OZF_FUNDS_ALL_VL
2662: WHERE PREV_FUND_ID IS NOT NULL
2663: AND TRANSFERED_FLAG IS NULL
2664: AND STATUS_CODE IN('ACTIVE','DRAFT');
2665:

Line 2669: FROM OZF_FUNDS_ALL_VL

2665:
2666: --- get end date for previous fund.
2667: CURSOR c_prec_fund (p_fund_id IN NUMBER) IS
2668: SELECT end_date_active,object_version_number
2669: FROM OZF_FUNDS_ALL_VL
2670: WHERE fund_id = p_fund_id;
2671:
2672: BEGIN
2673:

Line 2890: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2886: l_fund_id NUMBER := p_fund_id;
2887: l_hierarchy_flag VARCHAR2(30) := NVL(p_hierarchy_flag,'N');
2888: l_amount_flag VARCHAR2(30) := NVL(p_amount_flag,'N');
2889: -- to store the parent budget information
2890: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2891: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2892: -- to store the child budget informations
2893: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2894: l_child_fund_rec_type OZF_Funds_PVT.fund_rec_type;

Line 2893: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;

2889: -- to store the parent budget information
2890: l_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2891: l_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2892: -- to store the child budget informations
2893: l_child_fund_rec OZF_FUNDS_ALL_VL%ROWTYPE;
2894: l_child_fund_rec_type OZF_Funds_PVT.fund_rec_type;
2895: l_start_date_active DATE;
2896: l_end_date_active DATE;
2897: l_parent_fund_id NUMBER;

Line 2913: SELECT * FROM ozf_funds_all_vl

2909: TYPE dyna_get_fund_id IS REF CURSOR;
2910: c_get_fund_id dyna_get_fund_id;
2911:
2912: CURSOR c_get_fund_details(p_fund_id IN NUMBER) IS
2913: SELECT * FROM ozf_funds_all_vl
2914: WHERE fund_id = p_fund_id
2915: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2916: WHERE prev_fund_id = p_fund_id);
2917:

Line 2920: SELECT * from ozf_funds_all_vl

2916: WHERE prev_fund_id = p_fund_id);
2917:
2918: -- Gets the child budgets details
2919: CURSOR c_get_child_budget(p_fund_id IN NUMBER) IS
2920: SELECT * from ozf_funds_all_vl
2921: WHERE fund_id = p_fund_id
2922: AND status_code = 'ACTIVE'
2923: AND fund_id NOT IN (SELECT NVL(prev_fund_id,-99) FROM ozf_funds_all_b
2924: WHERE prev_fund_id = p_fund_id);