DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_K_HEADERS

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

34: l_amount NUMBER;
35: l_interest_amount NUMBER;
36:
37: --start code pgomes 12/18/2002
38: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
41: l_late_policy okl_late_policies_v.name%TYPE;
42: l_prev_late_policy okl_late_policies_v.name%TYPE;

Line 39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;

35: l_interest_amount NUMBER;
36:
37: --start code pgomes 12/18/2002
38: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
41: l_late_policy okl_late_policies_v.name%TYPE;
42: l_prev_late_policy okl_late_policies_v.name%TYPE;
43:

Line 40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;

36:
37: --start code pgomes 12/18/2002
38: l_func_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
39: l_contract_currency okl_k_headers_full_v.currency_code%TYPE;
40: l_prev_contract_currency okl_k_headers_full_v.currency_code%TYPE;
41: l_late_policy okl_late_policies_v.name%TYPE;
42: l_prev_late_policy okl_late_policies_v.name%TYPE;
43:
44: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;

Line 48: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;

44: l_minimum_late_interest okl_late_policies_b.minimum_late_interest%TYPE;
45: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;
46: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;
47:
48: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
49: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
50: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
51:
52: l_last_updated_by NUMBER;

Line 49: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;

45: l_maximum_late_interest okl_late_policies_b.maximum_late_interest%TYPE;
46: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;
47:
48: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
49: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
50: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
51:
52: l_last_updated_by NUMBER;
53: l_last_update_login NUMBER;

Line 50: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;

46: l_late_int_minimum_balance okl_late_policies_b.late_int_minimum_balance%TYPE;
47:
48: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%type;
49: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%type;
50: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%type;
51:
52: l_last_updated_by NUMBER;
53: l_last_update_login NUMBER;
54: l_request_id NUMBER;

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

52: l_last_updated_by NUMBER;
53: l_last_update_login NUMBER;
54: l_request_id NUMBER;
55: --end code pgomes 12/18/2002
56: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
57:
58: ------------------------------------------------------------
59: -- Declare variables to call Accounting Engine.
60: ------------------------------------------------------------

Line 108: , OKL_K_HEADERS_FULL_V KHR

104: ,max('AR-INVOICE') invoice_flag
105: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
106: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
107: , OKL_BPD_AR_INV_LINES_V ARL
108: , OKL_K_HEADERS_FULL_V KHR
109: , OKC_RULE_GROUPS_B RGP
110: , OKC_RULES_B RUL
111: , okc_rules_b rul_exm
112: ,okc_rules_b rul_hld

Line 168: , OKL_K_HEADERS_FULL_V KHR

164: , max('CONS-INVOICE') invoice_flag
165: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
166: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
167: , OKL_CNSLD_AR_STRMS_B CNSLD
168: , OKL_K_HEADERS_FULL_V KHR
169: , OKC_RULE_GROUPS_B RGP
170: , OKC_RULES_B RUL
171: , okc_rules_b rul_exm
172: ,okc_rules_b rul_hld

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

723: l_stmv_rec.date_current := sysdate;
724: l_stmv_rec.comments := 'INVESTOR LATE INTEREST PAYABLE';
725: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
726: l_stmv_rec.source_id := cur_sec_strm.khr_id;
727: l_stmv_rec.source_table := 'OKL_K_HEADERS';
728: END IF;
729:
730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating INVESTOR LATE INTEREST PAYABLE Stream');
731:

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

769: l_selv_rec.ACCRUED_YN := 'Y';
770: l_selv_rec.sel_id := l_sel_id;
771: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
772: l_selv_rec.source_id := cur_sec_strm.khr_id;
773: l_selv_rec.source_table := 'OKL_K_HEADERS';
774: END IF;
775:
776: Okl_Sel_Pvt.insert_row(
777: p_api_version,

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

847: l_stmv_rec.date_current := sysdate;
848: l_stmv_rec.comments := 'INVESTOR LATE INTEREST PAYABLE';
849: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
850: l_stmv_rec.source_id := cur_sec_strm.khr_id;
851: l_stmv_rec.source_table := 'OKL_K_HEADERS';
852: END IF;
853:
854: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating INVESTOR LATE INTEREST PAYABLE Stream');
855:

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

893: l_selv_rec.ACCRUED_YN := 'Y';
894: l_selv_rec.sel_id := l_sel_id;
895: IF (cur_sec_strm.khr_id IS NOT NULL) THEN
896: l_selv_rec.source_id := cur_sec_strm.khr_id;
897: l_selv_rec.source_table := 'OKL_K_HEADERS';
898: END IF;
899:
900: Okl_Sel_Pvt.insert_row(
901: p_api_version,