DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_SALES_CREDIT_PUB

Line 4486: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type)

4482: , x_rdsv_tbl => l_rev_tbl);
4483: END create_rev_distr;
4484:
4485: PROCEDURE get_sales_cred(p_cle_id IN NUMBER,
4486: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type)
4487: IS
4488: CURSOR scrv_cur IS
4489: SELECT
4490: PERCENT,

Line 4517: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,

4513: END LOOP;
4514: END get_sales_cred;
4515:
4516: PROCEDURE create_sales_cred(p_cle_id IN NUMBER,
4517: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,
4518: x_status OUT NOCOPY VARCHAR2) IS
4519: l_api_version NUMBER := 1.0;
4520: l_msg_count NUMBER;
4521: l_msg_data VARCHAR2(2000);

Line 4522: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

4518: x_status OUT NOCOPY VARCHAR2) IS
4519: l_api_version NUMBER := 1.0;
4520: l_msg_count NUMBER;
4521: l_msg_data VARCHAR2(2000);
4522: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
4523: i NUMBER;
4524: BEGIN
4525: i := p_scrv_tbl.FIRST;
4526: LOOP

Line 4531: OKS_SALES_CREDIT_PUB.insert_Sales_credit(

4527: p_scrv_tbl(i).cle_id := p_cle_id;
4528: EXIT WHEN i = p_scrv_tbl.LAST;
4529: i := p_scrv_tbl.NEXT(i);
4530: END LOOP;
4531: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
4532: p_api_version => l_api_version,
4533: x_return_status => x_status,
4534: x_msg_count => l_msg_count,
4535: x_msg_data => l_msg_data,

Line 5233: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

5229: idx NUMBER;
5230: l_rgp_id NUMBER;
5231: l_return_status VARCHAR2(20);
5232: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
5233: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
5234: l_msg_index NUMBER;
5235: l_msg_data VARCHAR2(2000);
5236: l_total_pct NUMBER := 0;
5237: l_rev_found BOOLEAN := FALSE;