DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on FND_CURRENCIES

Line 1064: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE

1060: ------------------------------------------------------------------------------
1061: PROCEDURE get_currency_precision (
1062: x_return_status OUT NOCOPY VARCHAR2,
1063: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1064: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE
1065: ) IS
1066: CURSOR chr_csr (p_chr_id NUMBER) IS
1067: SELECT currency_code
1068: FROM okc_k_headers_v

Line 1073: FROM fnd_currencies

1069: WHERE id = p_chr_id;
1070:
1071: CURSOR curr_csr (p_curr_code VARCHAR2) IS
1072: SELECT precision
1073: FROM fnd_currencies
1074: WHERE currency_code = p_curr_code;
1075:
1076: curr_failed EXCEPTION;
1077: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

Line 1077: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;

1073: FROM fnd_currencies
1074: WHERE currency_code = p_curr_code;
1075:
1076: curr_failed EXCEPTION;
1077: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
1078: l_precision FND_CURRENCIES.PRECISION%TYPE;
1079:
1080: BEGIN
1081:

Line 1078: l_precision FND_CURRENCIES.PRECISION%TYPE;

1074: WHERE currency_code = p_curr_code;
1075:
1076: curr_failed EXCEPTION;
1077: l_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
1078: l_precision FND_CURRENCIES.PRECISION%TYPE;
1079:
1080: BEGIN
1081:
1082: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1135: p_precision IN FND_CURRENCIES.PRECISION%TYPE,

1131: p_cle_id IN NUMBER,
1132: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1133: p_fin_line_capital_amount IN NUMBER,
1134: p_tot_capital_amount IN NUMBER,
1135: p_precision IN FND_CURRENCIES.PRECISION%TYPE,
1136: p_rgpv_tbl IN rgpv_tbl_type,
1137: p_rg_count IN NUMBER,
1138: x_slh_rulv_tbl_out OUT NOCOPY rulv_tbl_type,
1139: x_slh_count OUT NOCOPY NUMBER,

Line 1556: p_precision IN FND_CURRENCIES.PRECISION%TYPE,

1552: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1553: p_line_csr_tbl IN line_csr_tbl,
1554: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1555: p_tot_capital_amount IN NUMBER,
1556: p_precision IN FND_CURRENCIES.PRECISION%TYPE,
1557: p_rgpv_tbl IN rgpv_tbl_type,
1558: x_slh_rulv_tbl_out OUT NOCOPY rulv_tbl_type,
1559: x_slh_count OUT NOCOPY NUMBER,
1560: x_sll_rulv_tbl_out OUT NOCOPY rulv_tbl_type,

Line 1910: l_precision FND_CURRENCIES.PRECISION%TYPE;

1906:
1907: l_api_name VARCHAR2(35) := 'apply_payment';
1908: l_proc_name VARCHAR2(35) := 'APPLY_PAYMENT';
1909: l_api_version CONSTANT NUMBER := 1;
1910: l_precision FND_CURRENCIES.PRECISION%TYPE;
1911:
1912: l_del_yn VARCHAR2(1) := 'N';
1913: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1914: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

Line 2279: l_precision FND_CURRENCIES.PRECISION%TYPE;

2275:
2276: l_api_name VARCHAR2(35) := 'apply_propery_tax_payment';
2277: l_proc_name VARCHAR2(35) := 'apply_propery_tax_payment';
2278: l_api_version CONSTANT NUMBER := 1;
2279: l_precision FND_CURRENCIES.PRECISION%TYPE;
2280:
2281: l_del_yn VARCHAR2(1) := 'N';
2282: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2283: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

Line 2598: l_precision FND_CURRENCIES.PRECISION%TYPE;

2594:
2595: l_api_name VARCHAR2(35) := 'apply_rollover_fee_payment';
2596: l_proc_name VARCHAR2(35) := 'apply_rollover_fee_payment';
2597: l_api_version CONSTANT NUMBER := 1;
2598: l_precision FND_CURRENCIES.PRECISION%TYPE;
2599:
2600: l_del_yn VARCHAR2(1) := 'N';
2601: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2602: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

Line 2933: l_precision FND_CURRENCIES.PRECISION%TYPE;

2929:
2930: l_api_name VARCHAR2(35) := 'apply_eligible_fee_payment';
2931: l_proc_name VARCHAR2(35) := 'apply_eligible_fee_payment';
2932: l_api_version CONSTANT NUMBER := 1;
2933: l_precision FND_CURRENCIES.PRECISION%TYPE;
2934:
2935: l_del_yn VARCHAR2(1) := 'N';
2936: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2937: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;