DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on OKS_SALES_CREDIT_PUB

Line 3946: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type)

3942: , x_rdsv_tbl => l_rev_tbl);
3943: END create_rev_distr;
3944:
3945: PROCEDURE get_sales_cred(p_cle_id IN NUMBER,
3946: x_scrv_tbl OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type)
3947: IS
3948: CURSOR scrv_cur IS
3949: SELECT
3950: PERCENT,

Line 3977: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,

3973: END LOOP;
3974: END get_sales_cred;
3975:
3976: PROCEDURE create_sales_cred(p_cle_id IN NUMBER,
3977: p_scrv_tbl IN OUT NOCOPY OKS_SALES_CREDIT_PUB.scrv_tbl_type,
3978: x_status OUT NOCOPY VARCHAR2) IS
3979: l_api_version NUMBER := 1.0;
3980: l_msg_count NUMBER;
3981: l_msg_data VARCHAR2(2000);

Line 3982: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

3978: x_status OUT NOCOPY VARCHAR2) IS
3979: l_api_version NUMBER := 1.0;
3980: l_msg_count NUMBER;
3981: l_msg_data VARCHAR2(2000);
3982: l_scrv_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;
3983: i NUMBER;
3984: BEGIN
3985: i := p_scrv_tbl.FIRST;
3986: LOOP

Line 3991: OKS_SALES_CREDIT_PUB.insert_Sales_credit(

3987: p_scrv_tbl(i).cle_id := p_cle_id;
3988: EXIT WHEN i = p_scrv_tbl.LAST;
3989: i := p_scrv_tbl.NEXT(i);
3990: END LOOP;
3991: OKS_SALES_CREDIT_PUB.insert_Sales_credit(
3992: p_api_version => l_api_version,
3993: x_return_status => x_status,
3994: x_msg_count => l_msg_count,
3995: x_msg_data => l_msg_data,

Line 4692: l_salescr_tbl OKS_SALES_CREDIT_PUB.scrv_tbl_type;

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;
4696: l_rev_found BOOLEAN := FALSE;