APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_REV_DISTR_PUB

Line 4431: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type)

4427:
4428: /** Code for changing/splitting service lines **/
4429:
4430: PROCEDURE get_rev_distr(p_cle_id IN NUMBER,
4431: x_rev_tbl OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type)
4432: IS
4433: CURSOR rev_cur IS
4434: SELECT chr_id
4435: , cle_id

Line 4461: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,

4457: END LOOP;
4458: END get_rev_distr;
4459:
4460: PROCEDURE create_rev_distr(p_cle_id IN NUMBER,
4461: p_rev_tbl IN OUT NOCOPY OKS_REV_DISTR_PUB.rdsv_tbl_type,
4462: x_status OUT NOCOPY VARCHAR2)
4463: IS
4464: l_api_version NUMBER := 1.0;
4465: l_msg_count NUMBER;

Line 4467: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

4463: IS
4464: l_api_version NUMBER := 1.0;
4465: l_msg_count NUMBER;
4466: l_msg_data VARCHAR2(2000);
4467: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;
4468: i NUMBER;
4469: BEGIN
4470: i := p_rev_tbl.FIRST;
4471: LOOP

Line 4476: OKS_REV_DISTR_PUB.insert_Revenue_Distr

4472: p_rev_tbl(i).cle_id := p_cle_id;
4473: EXIT WHEN i = p_rev_tbl.LAST;
4474: i := p_rev_tbl.NEXT(i);
4475: END LOOP;
4476: OKS_REV_DISTR_PUB.insert_Revenue_Distr
4477: (p_api_version => l_api_version
4478: , x_return_status => x_status
4479: , x_msg_count => l_msg_count
4480: , x_msg_data => l_msg_data

Line 5232: l_rev_tbl OKS_REV_DISTR_PUB.rdsv_tbl_type;

5228: l_target_tbl copy_target_tbl;
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;