APPS.OKS_BILL_UTIL_PUB dependencies on OKS_REV_DISTR_PUB

Line 1505: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type) IS

1501:
1502: /** Code for changing/splitting service lines **/
1503:
1504: procedure get_rev_distr(p_cle_id IN NUMBER,
1505: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type) IS
1506: cursor rev_cur is
1507: select
1508: chr_id, cle_id,
1509: account_class,

Line 1534: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,

1530: end loop;
1531: end get_rev_distr;
1532:
1533: procedure create_rev_distr(p_cle_id IN NUMBER,
1534: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,
1535: x_status OUT NOCOPY VARCHAR2) IS
1536: l_api_version NUMBER := 1.0;
1537: l_msg_count NUMBER;
1538: l_msg_data VARCHAR2(2000);

Line 1539: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

1535: x_status OUT NOCOPY VARCHAR2) IS
1536: l_api_version NUMBER := 1.0;
1537: l_msg_count NUMBER;
1538: l_msg_data VARCHAR2(2000);
1539: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
1540: i NUMBER;
1541: begin
1542: i := p_rev_tbl.FIRST;
1543: Loop

Line 1548: OKS_REV_DISTR_PUB.insert_Revenue_Distr(

1544: p_rev_tbl(i).cle_id := p_cle_id;
1545: exit when i = p_rev_tbl.LAST;
1546: i := p_rev_tbl.NEXT(i);
1547: End Loop;
1548: OKS_REV_DISTR_PUB.insert_Revenue_Distr(
1549: p_api_version => l_api_version,
1550: x_return_status => x_status,
1551: x_msg_count => l_msg_count,
1552: x_msg_data => l_msg_data,

Line 1913: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

1909:
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;