DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_SALES_CREDIT_PUB

Line 1524: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type) IS

1520: x_rdsv_tbl => l_rev_tbl);
1521: end create_rev_distr;
1522:
1523: procedure get_sales_cred(p_cle_id IN NUMBER,
1524: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type) IS
1525: cursor scrv_cur is
1526: select
1527: percent,
1528: chr_id,

Line 1554: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,

1550: end loop;
1551: end get_sales_cred;
1552:
1553: procedure create_sales_cred(p_cle_id IN NUMBER,
1554: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,
1555: x_status OUT NOCOPY VARCHAR2) IS
1556: l_api_version NUMBER := 1.0;
1557: l_msg_count NUMBER;
1558: l_msg_data VARCHAR2(2000);

Line 1559: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

1555: x_status OUT NOCOPY VARCHAR2) IS
1556: l_api_version NUMBER := 1.0;
1557: l_msg_count NUMBER;
1558: l_msg_data VARCHAR2(2000);
1559: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1560: i NUMBER;
1561: begin
1562: i := p_scrv_tbl.FIRST;
1563: Loop

Line 1568: OKS_SALES_CREDIT_PUB.insert_Sales_credit(

1564: p_scrv_tbl(i).cle_id := p_cle_id;
1565: exit when i = p_scrv_tbl.LAST;
1566: i := p_scrv_tbl.NEXT(i);
1567: End Loop;
1568: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
1569: p_api_version => l_api_version,
1570: x_return_status => x_status,
1571: x_msg_count => l_msg_count,
1572: x_msg_data => l_msg_data,

Line 1880: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

1876: idx NUMBER;
1877: l_rgp_id NUMBER;
1878: l_return_status VARCHAR2(20);
1879: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
1880: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1881: l_msg_index NUMBER;
1882: l_msg_data VARCHAR2(2000);
1883: l_total_pct NUMBER := 0;
1884: l_rev_found BOOLEAN := FALSE;