APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_REV_DISTR_PUB

Line 3891: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type)

3887:
3888: /** Code for changing/splitting service lines **/
3889:
3890: PROCEDURE get_rev_distr(p_cle_id IN NUMBER,
3891: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type)
3892: IS
3893: CURSOR rev_cur IS
3894: SELECT chr_id
3895: , cle_id

Line 3921: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,

3917: END LOOP;
3918: END get_rev_distr;
3919:
3920: PROCEDURE create_rev_distr(p_cle_id IN NUMBER,
3921: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,
3922: x_status OUT NOCOPY VARCHAR2)
3923: IS
3924: l_api_version NUMBER := 1.0;
3925: l_msg_count NUMBER;

Line 3927: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

3923: IS
3924: l_api_version NUMBER := 1.0;
3925: l_msg_count NUMBER;
3926: l_msg_data VARCHAR2(2000);
3927: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
3928: i NUMBER;
3929: BEGIN
3930: i := p_rev_tbl.FIRST;
3931: LOOP

Line 3936: OKS_REV_DISTR_PUB.insert_Revenue_Distr

3932: p_rev_tbl(i).cle_id := p_cle_id;
3933: EXIT WHEN i = p_rev_tbl.LAST;
3934: i := p_rev_tbl.NEXT(i);
3935: END LOOP;
3936: OKS_REV_DISTR_PUB.insert_Revenue_Distr
3937: (p_api_version => l_api_version
3938: , x_return_status => x_status
3939: , x_msg_count => l_msg_count
3940: , x_msg_data => l_msg_data

Line 4691: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

4687: l_target_tbl copy_target_tbl;
4688: idx NUMBER;
4689: l_rgp_id NUMBER;
4690: l_return_status VARCHAR2(20);
4691: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
4692: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
4693: l_msg_index NUMBER;
4694: l_msg_data VARCHAR2(2000);
4695: l_total_pct NUMBER := 0;