DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_RULES_V

Line 990: FROM OKC_RULES_V

986: --Also added FND_DATE.canonical_to_date(rule_information2) to covert the rule_information2 to date format
987: CURSOR l_okl_stub_start_csr
988: IS
989: SELECT MAX(FND_DATE.canonical_to_date(RULE_INFORMATION2)+to_number(RULE_INFORMATION7)) start_date
990: FROM OKC_RULES_V
991: WHERE rgp_id = p_rgp_id
992: AND dnz_chr_id = p_dnz_chr_id
993: AND object2_id1 = p_slh_id
994: AND id <> p_rule_id

Line 1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,

1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1883: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

1887: l_api_version CONSTANT NUMBER := 1.0;
1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2154: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:

Line 2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;

2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
2165: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2828: l_flag VARCHAR2(1) := 'N';
2829: l_term okl_k_headers.term_duration%TYPE;
2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);

Line 3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

3070: l_api_version CONSTANT NUMBER := 1.0;
3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:

Line 3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

3686:
3687: l_term okl_k_headers.term_duration%TYPE;
3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;