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_LTE_CHRG_PVT dependencies on OKL_K_HEADERS

Line 50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;
47: l_error_flag BOOLEAN := FALSE;
48:
49: --start code pgomes 12/18/2002
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;

Line 51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;

47: l_error_flag BOOLEAN := FALSE;
48:
49: --start code pgomes 12/18/2002
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;
55:

Line 52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;

48:
49: --start code pgomes 12/18/2002
50: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
51: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
52: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
53: l_late_policy okl_late_policies_v.name%TYPE;
54: l_prev_late_policy okl_late_policies_v.name%TYPE;
55:
56:

Line 67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

63: l_late_chrg_rate okl_late_policies_v.late_chrg_rate%TYPE;
64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:
67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;

Line 68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;

64:
65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:
67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;
72: l_last_update_login NUMBER;

Line 69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

65: l_late_charge_amt okl_strm_elements_v.amount%TYPE;
66:
67: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
68: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
69: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
70:
71: l_last_updated_by NUMBER;
72: l_last_update_login NUMBER;
73: l_request_id NUMBER;

Line 88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636

84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
89:
90: --vdamerla bug 5474844
91: l_investor_disb_flag varchar2(1);
92:

Line 120: ,okl_k_headers_full_v khr

116: RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
117: and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
118: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) lpt
119: ,okl_bpd_ar_inv_lines_v lpt1
120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld

Line 174: ,okl_k_headers_full_v khr

170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM
174: ,okl_k_headers_full_v khr
175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul
177: ,okc_rules_b rul_exm
178: ,okc_rules_b rul_hld

Line 261: ,okl_k_headers_full_v khr

257: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
258: ,okl_bpd_ar_inv_lines_v orig_arl
259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld

Line 368: ,okl_k_headers_full_v khr

364: AND LN.ID = ST.LLN_ID
365: AND HD.ID = LN.CNR_ID
366: AND SM.ID = ST.STY_ID) last
367: ,okl_strm_elements_v sel
368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld

Line 999: l_stmv_rec.source_table := 'OKL_K_HEADERS';

995: l_stmv_rec.date_current := sysdate;
996: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
997: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
998: l_stmv_rec.source_id := cur_sec_strm.khr_id;
999: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1000: END IF;
1001:
1002: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1003:

Line 1046: l_selv_rec.source_table := 'OKL_K_HEADERS';

1042: l_selv_rec.ACCRUED_YN := 'Y';
1043: l_selv_rec.sel_id := l_sel_id;
1044: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1045: l_selv_rec.source_id := cur_sec_strm.khr_id;
1046: l_selv_rec.source_table := 'OKL_K_HEADERS';
1047: END IF;
1048:
1049: Okl_Sel_Pvt.insert_row(
1050: p_api_version,

Line 1149: l_stmv_rec.source_table := 'OKL_K_HEADERS';

1145: l_stmv_rec.date_current := sysdate;
1146: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
1147: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1148: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1149: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1150: END IF;
1151:
1152: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1153:

Line 1197: l_selv_rec.source_table := 'OKL_K_HEADERS';

1193: l_selv_rec.ACCRUED_YN := 'Y';
1194: l_selv_rec.sel_id := l_sel_id;
1195: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1196: l_selv_rec.source_id := cur_sec_strm.khr_id;
1197: l_selv_rec.source_table := 'OKL_K_HEADERS';
1198: END IF;
1199:
1200: Okl_Sel_Pvt.insert_row(
1201: p_api_version,

Line 1700: l_stmv_rec.source_table := 'OKL_K_HEADERS';

1696: -- streams which are used as a condn to pick these streams
1697: -- while running Investor Disbursement program
1698: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1699: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1700: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1701: END IF;
1702: -- gboomina Bug 6797000 - End
1703: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1704:

Line 1749: l_selv_rec.source_table := 'OKL_K_HEADERS';

1745: -- streams which are used as a condn to pick these streams
1746: -- while running Investor Disbursement program
1747: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1748: l_selv_rec.source_id := cur_sec_strm.khr_id;
1749: l_selv_rec.source_table := 'OKL_K_HEADERS';
1750: END IF;
1751: -- gboomina Bug 6797000 - End
1752:
1753: --@IMPORTANT@ Uncomment out this code once lsm_id is added to okl_strm_elements

Line 1859: l_stmv_rec.source_table := 'OKL_K_HEADERS';

1855: l_stmv_rec.date_current := sysdate;
1856: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
1857: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1858: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1859: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1860: END IF;
1861:
1862: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1863:

Line 1908: l_selv_rec.source_table := 'OKL_K_HEADERS';

1904: l_selv_rec.ACCRUED_YN := 'Y';
1905: l_selv_rec.sel_id := l_sel_id;
1906: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1907: l_selv_rec.source_id := cur_sec_strm.khr_id;
1908: l_selv_rec.source_table := 'OKL_K_HEADERS';
1909: END IF;
1910:
1911: Okl_Sel_Pvt.insert_row(
1912: p_api_version,