DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_SALES_CREDIT_PUB

Line 1558: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type) IS

1554: x_rdsv_tbl => l_rev_tbl);
1555: end create_rev_distr;
1556:
1557: procedure get_sales_cred(p_cle_id IN NUMBER,
1558: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type) IS
1559: cursor scrv_cur is
1560: select
1561: percent,
1562: chr_id,

Line 1588: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,

1584: end loop;
1585: end get_sales_cred;
1586:
1587: procedure create_sales_cred(p_cle_id IN NUMBER,
1588: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,
1589: x_status OUT NOCOPY VARCHAR2) IS
1590: l_api_version NUMBER := 1.0;
1591: l_msg_count NUMBER;
1592: l_msg_data VARCHAR2(2000);

Line 1593: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

1589: x_status OUT NOCOPY VARCHAR2) IS
1590: l_api_version NUMBER := 1.0;
1591: l_msg_count NUMBER;
1592: l_msg_data VARCHAR2(2000);
1593: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1594: i NUMBER;
1595: begin
1596: i := p_scrv_tbl.FIRST;
1597: Loop

Line 1602: OKS_SALES_CREDIT_PUB.insert_Sales_credit(

1598: p_scrv_tbl(i).cle_id := p_cle_id;
1599: exit when i = p_scrv_tbl.LAST;
1600: i := p_scrv_tbl.NEXT(i);
1601: End Loop;
1602: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
1603: p_api_version => l_api_version,
1604: x_return_status => x_status,
1605: x_msg_count => l_msg_count,
1606: x_msg_data => l_msg_data,

Line 1914: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

1910: idx NUMBER;
1911: l_rgp_id NUMBER;
1912: l_return_status VARCHAR2(20);
1913: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
1914: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
1915: l_msg_index NUMBER;
1916: l_msg_data VARCHAR2(2000);
1917: l_total_pct NUMBER := 0;
1918: l_rev_found BOOLEAN := FALSE;