[Home] [Help]
767: -- 1) It creates a offer for a accrual fund and pushes all th eligibility
768: -- information of the fund to QP
769: -- 2) It also create =a record in the ozf_Act_budgets APi for the offer and the fund
770: --Parameters
771: -- (p_fund_rec IN OZF_FUNDS_PVT.fund_rec_type ,
772: -- p_csch_id IN NUMBER := NULL, If a schedule id is passed then the offer
773: -- would be associated to the schedule else to the fund
774: -- p_api_version IN NUMBER,
775: -- x_msg_count OUT NUMBER,
784: -- Srinivasa Rudaravarapu Updated process offer for 11.5.9
785: -- NOTES
786: ---------------------------------------------------------------------
787: PROCEDURE process_offers(
788: p_fund_rec IN ozf_funds_pvt.fund_rec_type,
789: p_csch_id IN NUMBER := NULL -- this is not used anymore
790: ,
791: p_api_version IN NUMBER,
792: p_mode IN VARCHAR2 := jtf_plsql_api.g_create,
1264: -- 01/15/2001 Mumu Pande Create.
1265: -- NOTES
1266: ---------------------------------------------------------------------
1267: PROCEDURE process_approval(
1268: p_fund_rec IN ozf_funds_pvt.fund_rec_type,
1269: p_mode IN VARCHAR2,
1270: p_old_fund_status IN VARCHAR2 := NULL,
1271: x_return_status OUT NOCOPY VARCHAR2,
1272: x_msg_count OUT NOCOPY NUMBER,
1504: -- x_new_status_id OUT NUMBER
1505: -- x_return_status OUT VARCAHR2
1506: -----------------------------------------------------------------------
1507: PROCEDURE update_fund_status(
1508: p_fund_rec IN ozf_funds_pvt.fund_rec_type,
1509: x_new_status_code OUT NOCOPY VARCHAR2,
1510: x_new_status_id OUT NOCOPY NUMBER,
1511: x_submit_budget_approval OUT NOCOPY VARCHAR2,
1512: x_submit_child_approval OUT NOCOPY VARCHAR2,
1877: -- x_return_status OUT VARCAHR2
1878: -- x_msg_data OUT VARCHAR2
1879: -----------------------------------------------------------------------
1880: PROCEDURE process_accrual(
1881: p_fund_rec IN ozf_funds_pvt.fund_rec_type,
1882: p_api_version IN NUMBER,
1883: p_mode IN VARCHAR2,
1884: p_old_fund_status IN VARCHAR2 := NULL,
1885: x_return_status OUT NOCOPY VARCHAR2,
1892: l_api_version CONSTANT NUMBER := 1.0;
1893: l_return_status VARCHAR2(1);
1894: l_msg_count NUMBER;
1895: l_msg_data VARCHAR2(4000);
1896: l_fund_rec ozf_funds_pvt.fund_rec_type := p_fund_rec;
1897: l_fund_id NUMBER;
1898: l_fund_status VARCHAR2(30);
1899: l_accrual_basis VARCHAR2(30);
1900: BEGIN