eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_K_HEADERS_B

Line 96: p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

92: p_init_msg_list IN VARCHAR2,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
97:
98: l_upfront_tax_prog_sts OKL_BOOK_CONTROLLER_TRX.progress_status%TYPE;
99:
100: BEGIN

Line 208: p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

204: p_init_msg_list IN VARCHAR2,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
209:
210: CURSOR c_rates_csr(p_chr_id IN NUMBER,
211: p_parameter_type_code IN VARCHAR2) IS
212: SELECT rate.effective_from_date

Line 790: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;

786: p_cle_id IN NUMBER := NULL,
787: p_rgp_id IN NUMBER := NULL )
788: RETURN DATE IS
789:
790: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
791: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
792: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
793:
794: l_start_date date;

Line 799: OKC_K_HEADERS_B

795:
796: cursor KHR_CSR(P_ID IN NUMBER) is
797: SELECT START_DATE
798: FROM
799: OKC_K_HEADERS_B
800: WHERE
801: ID = P_ID;
802:
803: cursor CLE_CSR(P_ID IN NUMBER) is

Line 854: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;

850: -- end date for which we create payment.
851: FUNCTION get_line_end_date(p_rgp_id IN NUMBER )
852: RETURN DATE
853: IS
854: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
855: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
856: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
857:
858: l_line_end_date date;

Line 862: from okc_k_headers_b

858: l_line_end_date date;
859:
860: cursor khr_csr(p_id in number) is
861: select end_date
862: from okc_k_headers_b
863: where id = p_id;
864:
865: cursor cle_csr(p_id in number) is
866: select end_date

Line 1003: FROM OKC_K_HEADERS_B

999:
1000: CURSOR l_okl_chr_start_csr
1001: IS
1002: SELECT START_DATE
1003: FROM OKC_K_HEADERS_B
1004: WHERE ID = p_dnz_chr_id;
1005:
1006: l_start_date DATE;
1007: l_sll_count NUMBER := 0;

Line 1164: FOR i IN ( SELECT end_date FROM okc_k_headers_b WHERE id = P_CHR_ID)

1160: l_end_date := l_end_date - 1;
1161:
1162: --For Bug#5441811 selecting the contract end date for calculating
1163: -- end dates in payment structure.
1164: FOR i IN ( SELECT end_date FROM okc_k_headers_b WHERE id = P_CHR_ID)
1165: LOOP
1166: l_contract_end_date := i.end_date;
1167: END LOOP;
1168: --Bug#5441811

Line 1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,

1872: p_init_msg_list IN VARCHAR2,
1873: x_return_status OUT NOCOPY VARCHAR2,
1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.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,

Line 2060: FROM OKC_K_HEADERS_B

2056: RETURN boolean IS
2057:
2058: cursor inv_dtls_csr(p_chr_id IN NUMBER) is
2059: SELECT scs_code
2060: FROM OKC_K_HEADERS_B
2061: WHERE ID = p_chr_id ;
2062: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
2063: SELECT kleb.amount amount
2064: FROM okc_k_lines_b cleb,

Line 2067: okc_k_headers_b chrb,

2063: SELECT kleb.amount amount
2064: FROM okc_k_lines_b cleb,
2065: okl_k_lines kleb,
2066: okc_line_styles_b lseb,
2067: okc_k_headers_b chrb,
2068: okc_rule_groups_b rg
2069: WHERE chrb.id = cleb.dnz_chr_id
2070: AND kleb.id = cleb.id
2071: AND cleb.lse_id = lseb.id

Line 2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,

2115: p_init_msg_list IN VARCHAR2,
2116: x_return_status OUT NOCOPY VARCHAR2,
2117: x_msg_count OUT NOCOPY NUMBER,
2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,

Line 2139: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;

2135: l NUMBER := 0;
2136: kount NUMBER := 0;
2137: empty_rec boolean := false;
2138:
2139: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
2140: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
2141: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
2142:
2143: l_crea_rulv_tbl rulv_tbl_type;

Line 2140: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;

2136: kount NUMBER := 0;
2137: empty_rec boolean := false;
2138:
2139: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
2140: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
2141: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
2142:
2143: l_crea_rulv_tbl rulv_tbl_type;
2144: l_updt_rulv_tbl rulv_tbl_type;

Line 2141: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;

2137: empty_rec boolean := false;
2138:
2139: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
2140: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
2141: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
2142:
2143: l_crea_rulv_tbl rulv_tbl_type;
2144: l_updt_rulv_tbl rulv_tbl_type;
2145: l_delt_rulv_tbl rulv_tbl_type;

Line 2192: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE

2188: -- bug
2189: A.AUTHORING_ORG_ID,
2190: A.CURRENCY_CODE,
2191: B.DEAL_TYPE -- Bug 4887014
2192: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE
2193: A.ID = P_CHR_ID
2194: AND A.ID = B.ID;
2195:
2196: --Changed query for performance --dkagrawa

Line 2202: okc_k_headers_b chrb,

2198: SELECT kleb.fee_type fee_type
2199: FROM okc_k_lines_b cleb,
2200: okl_k_lines kleb,
2201: okc_line_styles_b lseb,
2202: okc_k_headers_b chrb,
2203: okc_rule_groups_b rg
2204: WHERE chrb.id = cleb.dnz_chr_id
2205: AND kleb.id = cleb.id
2206: AND cleb.lse_id = lseb.id

Line 2246: FROM okc_k_headers_b chrb

2242: l_upfront_tax_pymt_yn VARCHAR2(1);
2243:
2244: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
2245: SELECT chrb.sts_code
2246: FROM okc_k_headers_b chrb
2247: WHERE chrb.id = p_chr_id;
2248:
2249: l_contract_rec l_contract_csr%ROWTYPE;
2250:

Line 3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3057: p_init_msg_list IN VARCHAR2,
3058: x_return_status OUT NOCOPY VARCHAR2,
3059: x_msg_count OUT NOCOPY NUMBER,
3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,

Line 3086: FROM okc_k_headers_b chrb

3082: l_upfront_tax_pymt_yn VARCHAR2(1);
3083:
3084: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
3085: SELECT chrb.sts_code
3086: FROM okc_k_headers_b chrb
3087: WHERE chrb.id = p_chr_id;
3088:
3089: l_contract_rec l_contract_csr%ROWTYPE;
3090:

Line 3447: FROM okc_k_headers_b chrb

3443: l_upfront_tax_pymt_yn VARCHAR2(1);
3444:
3445: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
3446: SELECT chrb.sts_code
3447: FROM okc_k_headers_b chrb
3448: WHERE chrb.id = p_chr_id;
3449:
3450: l_contract_rec l_contract_csr%ROWTYPE;
3451:

Line 3462: l_chr_id OKC_K_HEADERS_B.id%TYPE;

3458: AND cleb.id = rgp.cle_id;
3459:
3460: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;
3461: l_cle_id OKC_K_LINES_B.id%TYPE;
3462: l_chr_id OKC_K_HEADERS_B.id%TYPE;
3463:
3464: --Bug# 13973475
3465: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3466: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;

Line 3705: FROM OKC_K_HEADERS_B

3701:
3702: -- 4895333
3703: CURSOR get_sts_code_csr(p_id NUMBER) IS
3704: SELECT sts_code
3705: FROM OKC_K_HEADERS_B
3706: WHERE ID = p_id;
3707: l_sts_code okc_k_headers_b.sts_code%type;
3708:
3709: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS

Line 3707: l_sts_code okc_k_headers_b.sts_code%type;

3703: CURSOR get_sts_code_csr(p_id NUMBER) IS
3704: SELECT sts_code
3705: FROM OKC_K_HEADERS_B
3706: WHERE ID = p_id;
3707: l_sts_code okc_k_headers_b.sts_code%type;
3708:
3709: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS
3710: SELECT COUNT(1) counter
3711: FROM OKC_RULES_B