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 764: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;

760: p_cle_id IN NUMBER := NULL,
761: p_rgp_id IN NUMBER := NULL )
762: RETURN DATE IS
763:
764: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
765: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
766: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
767:
768: l_start_date date;

Line 773: OKC_K_HEADERS_B

769:
770: cursor KHR_CSR(P_ID IN NUMBER) is
771: SELECT START_DATE
772: FROM
773: OKC_K_HEADERS_B
774: WHERE
775: ID = P_ID;
776:
777: cursor CLE_CSR(P_ID IN NUMBER) is

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

824: -- end date for which we create payment.
825: FUNCTION get_line_end_date(p_rgp_id IN NUMBER )
826: RETURN DATE
827: IS
828: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
829: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
830: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
831:
832: l_line_end_date date;

Line 836: from okc_k_headers_b

832: l_line_end_date date;
833:
834: cursor khr_csr(p_id in number) is
835: select end_date
836: from okc_k_headers_b
837: where id = p_id;
838:
839: cursor cle_csr(p_id in number) is
840: select end_date

Line 977: FROM OKC_K_HEADERS_B

973:
974: CURSOR l_okl_chr_start_csr
975: IS
976: SELECT START_DATE
977: FROM OKC_K_HEADERS_B
978: WHERE ID = p_dnz_chr_id;
979:
980: l_start_date DATE;
981: l_sll_count NUMBER := 0;

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

1124: l_end_date := l_end_date - 1;
1125:
1126: --For Bug#5441811 selecting the contract end date for calculating
1127: -- end dates in payment structure.
1128: FOR i IN ( SELECT end_date FROM okc_k_headers_b WHERE id = P_CHR_ID)
1129: LOOP
1130: l_contract_end_date := i.end_date;
1131: END LOOP;
1132: --Bug#5441811

Line 1669: p_chr_id OKC_K_HEADERS_B.ID%TYPE,

1665: p_init_msg_list IN VARCHAR2,
1666: x_return_status OUT NOCOPY VARCHAR2,
1667: x_msg_count OUT NOCOPY NUMBER,
1668: x_msg_data OUT NOCOPY VARCHAR2,
1669: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,

Line 1853: FROM OKC_K_HEADERS_B

1849: RETURN boolean IS
1850:
1851: cursor inv_dtls_csr(p_chr_id IN NUMBER) is
1852: SELECT scs_code
1853: FROM OKC_K_HEADERS_B
1854: WHERE ID = p_chr_id ;
1855: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
1856: SELECT kleb.amount amount
1857: FROM okc_k_lines_b cleb,

Line 1860: okc_k_headers_b chrb,

1856: SELECT kleb.amount amount
1857: FROM okc_k_lines_b cleb,
1858: okl_k_lines kleb,
1859: okc_line_styles_b lseb,
1860: okc_k_headers_b chrb,
1861: okc_rule_groups_b rg
1862: WHERE chrb.id = cleb.dnz_chr_id
1863: AND kleb.id = cleb.id
1864: AND cleb.lse_id = lseb.id

Line 1912: p_chr_id OKC_K_HEADERS_B.ID%TYPE,

1908: p_init_msg_list IN VARCHAR2,
1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1913: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1914: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1915: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1916: p_pym_hdr_rec IN pym_hdr_rec_type,

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

1928: l NUMBER := 0;
1929: kount NUMBER := 0;
1930: empty_rec boolean := false;
1931:
1932: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
1933: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
1934: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
1935:
1936: l_crea_rulv_tbl rulv_tbl_type;

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

1929: kount NUMBER := 0;
1930: empty_rec boolean := false;
1931:
1932: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
1933: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
1934: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
1935:
1936: l_crea_rulv_tbl rulv_tbl_type;
1937: l_updt_rulv_tbl rulv_tbl_type;

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

1930: empty_rec boolean := false;
1931:
1932: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE := null;
1933: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE := null;
1934: l_ccode OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := null;
1935:
1936: l_crea_rulv_tbl rulv_tbl_type;
1937: l_updt_rulv_tbl rulv_tbl_type;
1938: l_delt_rulv_tbl rulv_tbl_type;

Line 1981: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE

1977: -- bug
1978: A.AUTHORING_ORG_ID,
1979: A.CURRENCY_CODE,
1980: B.DEAL_TYPE -- Bug 4887014
1981: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE
1982: A.ID = P_CHR_ID
1983: AND A.ID = B.ID;
1984:
1985: --Changed query for performance --dkagrawa

Line 1991: okc_k_headers_b chrb,

1987: SELECT kleb.fee_type fee_type
1988: FROM okc_k_lines_b cleb,
1989: okl_k_lines kleb,
1990: okc_line_styles_b lseb,
1991: okc_k_headers_b chrb,
1992: okc_rule_groups_b rg
1993: WHERE chrb.id = cleb.dnz_chr_id
1994: AND kleb.id = cleb.id
1995: AND cleb.lse_id = lseb.id

Line 2035: FROM okc_k_headers_b chrb

2031: l_upfront_tax_pymt_yn VARCHAR2(1);
2032:
2033: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
2034: SELECT chrb.sts_code
2035: FROM okc_k_headers_b chrb
2036: WHERE chrb.id = p_chr_id;
2037:
2038: l_contract_rec l_contract_csr%ROWTYPE;
2039:

Line 2793: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

2789: p_init_msg_list IN VARCHAR2,
2790: x_return_status OUT NOCOPY VARCHAR2,
2791: x_msg_count OUT NOCOPY NUMBER,
2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
2794: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2795: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2796: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2797: p_update_type IN VARCHAR2,

Line 2818: FROM okc_k_headers_b chrb

2814: l_upfront_tax_pymt_yn VARCHAR2(1);
2815:
2816: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
2817: SELECT chrb.sts_code
2818: FROM okc_k_headers_b chrb
2819: WHERE chrb.id = p_chr_id;
2820:
2821: l_contract_rec l_contract_csr%ROWTYPE;
2822:

Line 3176: FROM okc_k_headers_b chrb

3172: l_upfront_tax_pymt_yn VARCHAR2(1);
3173:
3174: CURSOR l_contract_csr(p_chr_id IN NUMBER) IS
3175: SELECT chrb.sts_code
3176: FROM okc_k_headers_b chrb
3177: WHERE chrb.id = p_chr_id;
3178:
3179: l_contract_rec l_contract_csr%ROWTYPE;
3180:

Line 3191: l_chr_id OKC_K_HEADERS_B.id%TYPE;

3187: AND cleb.id = rgp.cle_id;
3188:
3189: l_pymt_cle_rec l_pymt_cle_csr%ROWTYPE;
3190: l_cle_id OKC_K_LINES_B.id%TYPE;
3191: l_chr_id OKC_K_HEADERS_B.id%TYPE;
3192:
3193: begin
3194:
3195: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3407: FROM OKC_K_HEADERS_B

3403:
3404: -- 4895333
3405: CURSOR get_sts_code_csr(p_id NUMBER) IS
3406: SELECT sts_code
3407: FROM OKC_K_HEADERS_B
3408: WHERE ID = p_id;
3409: l_sts_code okc_k_headers_b.sts_code%type;
3410:
3411: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS

Line 3409: l_sts_code okc_k_headers_b.sts_code%type;

3405: CURSOR get_sts_code_csr(p_id NUMBER) IS
3406: SELECT sts_code
3407: FROM OKC_K_HEADERS_B
3408: WHERE ID = p_id;
3409: l_sts_code okc_k_headers_b.sts_code%type;
3410:
3411: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS
3412: SELECT COUNT(1) counter
3413: FROM OKC_RULES_B