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_OPEN_INTERFACE_PVT dependencies on OKL_PAYMENTS_INTERFACE

Line 2630: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,

2626: PROCEDURE check_payment_frequency_code(
2627: x_return_status OUT NOCOPY VARCHAR2,
2628: x_msg_count OUT NOCOPY NUMBER,
2629: x_msg_data OUT NOCOPY VARCHAR2,
2630: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2631: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2632: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2633: ) IS
2634: /*

Line 2635: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

2631: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2632: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2633: ) IS
2634: /*
2635: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2636: SELECT id1,
2637: uom_code
2638: FROM okx_tuom_v
2639: WHERE uom_class = 'OKL-TIME'

Line 2643: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

2639: WHERE uom_class = 'OKL-TIME'
2640: AND base_uom_flag = 'N'
2641: AND name = p_payment_freq_code;
2642: */
2643: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2644: SELECT id1,
2645: id1
2646: FROM okl_time_units_v
2647: WHERE name = p_payment_freq_code;

Line 2720: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,

2716: PROCEDURE check_payment_record(
2717: x_return_status OUT NOCOPY VARCHAR2,
2718: x_msg_count OUT NOCOPY NUMBER,
2719: x_msg_data OUT NOCOPY VARCHAR2,
2720: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2721: p_line_number IN okl_payments_interface.line_number%TYPE,
2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

Line 2721: p_line_number IN okl_payments_interface.line_number%TYPE,

2717: x_return_status OUT NOCOPY VARCHAR2,
2718: x_msg_count OUT NOCOPY NUMBER,
2719: x_msg_data OUT NOCOPY VARCHAR2,
2720: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2721: p_line_number IN okl_payments_interface.line_number%TYPE,
2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,

Line 2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,

2718: x_msg_count OUT NOCOPY NUMBER,
2719: x_msg_data OUT NOCOPY VARCHAR2,
2720: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2721: p_line_number IN okl_payments_interface.line_number%TYPE,
2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,

Line 2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

2720: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2721: p_line_number IN okl_payments_interface.line_number%TYPE,
2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

Line 2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,

2721: p_line_number IN okl_payments_interface.line_number%TYPE,
2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

Line 2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,

2722: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,

Line 2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,

2723: p_payment_type_code IN VARCHAR2,
2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

Line 2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

2724: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,

Line 2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

2725: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,

Line 2730: p_start_date IN okl_payments_interface.start_date%TYPE,

2726: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,

Line 2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

2727: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE

Line 2732: p_rate IN okl_payments_interface.rate%TYPE,

2728: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS

Line 2733: p_comments IN okl_payments_interface.comments%TYPE,

2729: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS
2737:

Line 2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,

2730: p_start_date IN okl_payments_interface.start_date%TYPE,
2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS
2737:
2738: x_id1 okx_tuom_v.id1%TYPE;

Line 2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE

2731: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2732: p_rate IN okl_payments_interface.rate%TYPE,
2733: p_comments IN okl_payments_interface.comments%TYPE,
2734: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS
2737:
2738: x_id1 okx_tuom_v.id1%TYPE;
2739: x_id2 okl_strmtyp_source_v.id1%TYPE;

Line 3125: FROM okl_payments_interface

3121: --
3122:
3123: CURSOR okl_payment_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3124: SELECT *
3125: FROM okl_payments_interface
3126: WHERE contract_number_old = p_contract_number;
3127:
3128:
3129: BEGIN -- Actual Procedure Starts Here

Line 22233: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

22229: x_msg_data OUT NOCOPY VARCHAR2,
22230: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22231: p_line_number IN okl_lines_interface.line_number%TYPE,
22232: p_payment_type_code IN VARCHAR2,
22233: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
22234: p_chr_id IN NUMBER,
22235: p_cle_id IN NUMBER,
22236: p_rg_id IN NUMBER,
22237: x_rgp_id OUT NOCOPY NUMBER,

Line 22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,

22429: x_msg_count OUT NOCOPY NUMBER,
22430: x_msg_data OUT NOCOPY VARCHAR2,
22431: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22432: p_line_number IN okl_lines_interface.line_number%TYPE,
22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

Line 22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,

22430: x_msg_data OUT NOCOPY VARCHAR2,
22431: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22432: p_line_number IN okl_lines_interface.line_number%TYPE,
22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,

Line 22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,

22431: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22432: p_line_number IN okl_lines_interface.line_number%TYPE,
22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

Line 22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

22432: p_line_number IN okl_lines_interface.line_number%TYPE,
22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,

Line 22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,

Line 22438: p_start_date IN okl_payments_interface.start_date%TYPE,

22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,

Line 22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,

Line 22440: p_rate IN okl_payments_interface.rate%TYPE,

22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22444: p_slh_rulv_rec IN rulv_rec_type,

Line 22441: p_comments IN okl_payments_interface.comments%TYPE,

22437: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22444: p_slh_rulv_rec IN rulv_rec_type,
22445: p_chr_id IN NUMBER,

Line 22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,

22438: p_start_date IN okl_payments_interface.start_date%TYPE,
22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22444: p_slh_rulv_rec IN rulv_rec_type,
22445: p_chr_id IN NUMBER,
22446: p_cle_id IN NUMBER,

Line 22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,

22439: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22440: p_rate IN okl_payments_interface.rate%TYPE,
22441: p_comments IN okl_payments_interface.comments%TYPE,
22442: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22443: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22444: p_slh_rulv_rec IN rulv_rec_type,
22445: p_chr_id IN NUMBER,
22446: p_cle_id IN NUMBER,
22447: p_rgp_id IN NUMBER

Line 27281: l_asset_number_prev okl_payments_interface.asset_number%TYPE;

27277: x_comb_id NUMBER;
27278: x_rgp_id NUMBER;
27279: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27280: l_line_number_prev okl_lines_interface.line_number%TYPE;
27281: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27282: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27283: l_pmnt_sch_num_prev NUMBER;
27284: l_start_date_prev DATE;
27285: l_number_of_periods_prev NUMBER;

Line 27282: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;

27278: x_rgp_id NUMBER;
27279: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27280: l_line_number_prev okl_lines_interface.line_number%TYPE;
27281: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27282: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27283: l_pmnt_sch_num_prev NUMBER;
27284: l_start_date_prev DATE;
27285: l_number_of_periods_prev NUMBER;
27286: x_pmnt_freq_id okx_tuom_v.id1%TYPE;

Line 28252: FROM okl_payments_interface

28248: --
28249: CURSOR okl_payment_csr (p_contract_number_old VARCHAR2,
28250: p_line_number NUMBER) IS
28251: SELECT *
28252: FROM okl_payments_interface
28253: WHERE contract_number_old = p_contract_number_old
28254: AND payment_type_code <> 'RENT' -- Bug 5155206
28255: AND ( (line_number = p_line_number
28256: AND

Line 28354: FROM okl_payments_interface

28350: type RENT only */
28351: CURSOR okl_payment_rent_csr (p_contract_number_old VARCHAR2,
28352: p_line_number NUMBER) IS
28353: SELECT *
28354: FROM okl_payments_interface
28355: WHERE contract_number_old = p_contract_number_old
28356: AND payment_type_code = 'RENT'
28357: AND ( (line_number = p_line_number
28358: AND

Line 30348: --to utilize these variables for processing non rent records in okl_payments_interface

30344:
30345: -- Save current values for future comparison
30346: --abhsaxen 13-feb-2008 bug#6773219
30347: --commented this portion and added the same just at the end of line processing loop
30348: --to utilize these variables for processing non rent records in okl_payments_interface
30349: --like ESTIMATED PERSONAL PROPERTY TAX
30350: --l_prev_asset_number := okl_line_rec.asset_number;
30351: --l_prev_corp_book := okl_line_rec.asset_corporate_book;
30352: --l_prev_tax_book := okl_line_rec.tax_book;