[Home] [Help]
12: -- CURSOR csr_act_inv,CURSOR csr_var_inv.
13: -- 09-Jan-03 dthota o Changed p_period_date to VARCHAR2 from DATE in
14: -- create_payment_term_batch,CURSOR csr_for_inv,
15: -- CURSOR csr_act_inv,CURSOR csr_var_inv and added
16: -- fnd_date.canonical_to_date before p_period_date
17: -- in the WHERE clauses of the cursors.
18: -- Fix for bug # 2733870
19: -- 21-Oct-04 vmmehta o Bug# 3942264. Added code to reset term_status if term
20: -- creation fails for actual/forecasted/variance terms.
117: AND nvl(for_per_rent,0) <> 0
118: AND forecasted_exp_code = 'N'
119: AND forecasted_term_status = decode(p_period_id,null,'N','Y')
120: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'FORECASTED') ='N'
121: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
122: ORDER BY invoice_date;
123:
124: /* Get the actual rent amounts */
125:
137: AND actual_exp_code = 'N'
138: AND nvl(actual_invoiced_amount,0) <> 0
139: AND actual_term_status = decode(p_period_id,null,'N','Y')
140: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'ACTUAL') ='N'
141: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
142: ORDER BY invoice_date;
143:
144: /* get the actual-forecasted rent amounts */
145:
164: AND gd.period_id = inv.period_id
165: AND gd.var_rent_id = inv.var_rent_id
166: AND nvl(gd.forecasted_exp_code,'N') = 'N')
167: AND pn_variable_amount_pkg.find_if_term_exists(inv.var_rent_inv_id,'VARIANCE') = 'N'
168: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
169: ORDER BY inv.invoice_date;
170:
171: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS
172: SELECT payment_term_id