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 178: ,okl_k_headers_full_v khr

174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm
182: ,okc_rules_b rul_hld

Line 266: ,okl_k_headers_full_v khr

262: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) last_arv
263: ,okl_bpd_ar_inv_lines_v orig_arl
264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld

Line 373: ,okl_k_headers_full_v khr

369: AND LN.ID = ST.LLN_ID
370: AND HD.ID = LN.CNR_ID
371: AND SM.ID = ST.STY_ID) last
372: ,okl_strm_elements_v sel
373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld

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

1002: l_stmv_rec.date_current := sysdate;
1003: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
1004: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1005: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1006: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1007: END IF;
1008:
1009: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1010:

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

1049: l_selv_rec.ACCRUED_YN := 'Y';
1050: l_selv_rec.sel_id := l_sel_id;
1051: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1052: l_selv_rec.source_id := cur_sec_strm.khr_id;
1053: l_selv_rec.source_table := 'OKL_K_HEADERS';
1054: END IF;
1055:
1056: Okl_Sel_Pvt.insert_row(
1057: p_api_version,

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

1152: l_stmv_rec.date_current := sysdate;
1153: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
1154: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1155: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1156: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1157: END IF;
1158:
1159: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1160:

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

1200: l_selv_rec.ACCRUED_YN := 'Y';
1201: l_selv_rec.sel_id := l_sel_id;
1202: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1203: l_selv_rec.source_id := cur_sec_strm.khr_id;
1204: l_selv_rec.source_table := 'OKL_K_HEADERS';
1205: END IF;
1206:
1207: Okl_Sel_Pvt.insert_row(
1208: p_api_version,

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

1704: -- streams which are used as a condn to pick these streams
1705: -- while running Investor Disbursement program
1706: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1707: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1708: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1709: END IF;
1710: -- gboomina Bug 6797000 - End
1711: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1712:

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

1753: -- streams which are used as a condn to pick these streams
1754: -- while running Investor Disbursement program
1755: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1756: l_selv_rec.source_id := cur_sec_strm.khr_id;
1757: l_selv_rec.source_table := 'OKL_K_HEADERS';
1758: END IF;
1759: -- gboomina Bug 6797000 - End
1760:
1761: --@IMPORTANT@ Uncomment out this code once lsm_id is added to okl_strm_elements

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

1863: l_stmv_rec.date_current := sysdate;
1864: l_stmv_rec.comments := 'INVESTOR LATE FEE PAYABLE';
1865: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1866: l_stmv_rec.source_id := cur_sec_strm.khr_id;
1867: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1868: END IF;
1869:
1870: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1871:

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

1912: l_selv_rec.ACCRUED_YN := 'Y';
1913: l_selv_rec.sel_id := l_sel_id;
1914: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
1915: l_selv_rec.source_id := cur_sec_strm.khr_id;
1916: l_selv_rec.source_table := 'OKL_K_HEADERS';
1917: END IF;
1918:
1919: Okl_Sel_Pvt.insert_row(
1920: p_api_version,