APPS.IGIRRPS dependencies on IGI_RPI_STANDING_CHARGES

Line 16: CHARGE_STATUS CONSTANT IGI_RPI_STANDING_CHARGES_ALL.STATUS%TYPE

12: ALREADY_SYNC_STATUS CONSTANT VARCHAR2(1) := 'Y';
13: NOT_SYNC_STATUS CONSTANT VARCHAR2(1) := 'N';
14: SYNCHRONIZED_STATUS CONSTANT VARCHAR2(1) := NOT_SYNC_STATUS;
15:
16: CHARGE_STATUS CONSTANT IGI_RPI_STANDING_CHARGES_ALL.STATUS%TYPE
17: := 'ACTIVE';
18: INVOICING_RULE CONSTANT
19: IGI_RPI_STANDING_CHARGES_ALL.ADVANCE_ARREARS_IND%TYPE := 'ADVANCE';
20:

Line 19: IGI_RPI_STANDING_CHARGES_ALL.ADVANCE_ARREARS_IND%TYPE := 'ADVANCE';

15:
16: CHARGE_STATUS CONSTANT IGI_RPI_STANDING_CHARGES_ALL.STATUS%TYPE
17: := 'ACTIVE';
18: INVOICING_RULE CONSTANT
19: IGI_RPI_STANDING_CHARGES_ALL.ADVANCE_ARREARS_IND%TYPE := 'ADVANCE';
20:
21: --Commenting out WriteToLogFile as fnd_logging to be used bug 3199481 (Start)
22: /*
23: PROCEDURE WriteToLog ( pp_mesg in VARCHAR2) IS

Line 184: FROM igi_rpi_standing_charges sc

180: )
181: RETURN DATE IS
182: CURSOR c_sc IS
183: SELECT sc.period_name
184: FROM igi_rpi_standing_charges sc
185: WHERE sc.standing_charge_id = pp_standing_charge_id
186: AND sc.set_of_books_id = ( select set_of_books_id
187: from ar_system_parameters )
188: AND sc.status = CHARGE_STATUS

Line 236: FROM igi_rpi_standing_charges sc

232: RETURN DATE IS
233:
234: CURSOR c_sc IS
235: SELECT sc.period_name
236: FROM igi_rpi_standing_charges sc
237: WHERE sc.standing_charge_id = pp_standing_charge_id
238: AND sc.set_of_books_id = ( select set_of_books_id
239: from ar_system_parameters )
240: AND sc.status = CHARGE_STATUS

Line 292: FROM igi_rpi_standing_charges sc

288: sc.start_date, sc.standing_charge_date
289: , sc.end_date , sc.next_due_date , sc.previous_due_date
290: , sc.advance_arrears_ind
291: , nvl(sc.date_synchronized_flag,ALREADY_SYNC_STATUS) date_synchronized_flag
292: FROM igi_rpi_standing_charges sc
293: WHERE sc.standing_charge_id = cp_standing_charge_id
294: AND sc.generate_sequence = cp_generate_sequence
295: AND sc.set_of_books_id = ( select set_of_books_id
296: from ar_system_parameters )

Line 387: UPDATE IGI_RPI_STANDING_CHARGES

383: /*Bug no 2688741 Commented by shsaxena*/
384: -- return ;
385: END IF;
386:
387: UPDATE IGI_RPI_STANDING_CHARGES
388: SET next_due_date = ld_new_next_due_date,
389: standing_charge_date = ld_new_sc_date,
390: previous_due_date = lv_update_sc.next_due_date,
391: date_synchronized_flag = ALREADY_SYNC_STATUS

Line 452: FROM igi_rpi_standing_charges sc

448: CURSOR c_undo_sc IS
449: SELECT sc.standing_charge_id, sc.generate_sequence
450: , sc.batch_source_id
451: , sc.charge_reference
452: FROM igi_rpi_standing_charges sc
453: WHERE sc.set_of_books_id = p_set_of_books_id
454: AND sc.standing_charge_id = nvl( p_standing_charge_id
455: , sc.standing_charge_id )
456: AND sc.batch_source_id = nvl(p_batch_source_id,

Line 473: , igi_rpi_standing_charges rsc

469: , rsc.advance_arrears_ind
470: , rsc.batch_source_id
471: , rsc.default_invoicing_rule
472: from ra_customer_trx rct
473: , igi_rpi_standing_charges rsc
474: where rct.batch_source_id = nvl(cp_batch_source_id,
475: rct.batch_source_id )
476: and rct.set_of_books_id = p_set_of_books_id
477: and to_char(rsc.standing_charge_id) = rct.interface_header_attribute1

Line 651: update igi_rpi_standing_charges

647: ' Interface information deleted for '||
648: l_sc.standing_charge_id );
649: END IF;
650: -- bug 3199481, end block
651: update igi_rpi_standing_charges
652: set date_synchronized_flag = ALREADY_SYNC_STATUS
653: where standing_charge_id = l_sc.standing_charge_id
654: and generate_sequence = l_sc.generate_sequence
655: and date_synchronized_flag = NOT_SYNC_STATUS

Line 706: From igi_rpi_standing_charges

702:
703: /* fetch new value of next due date*/
704: Select next_due_date
705: into l_next_due_date
706: From igi_rpi_standing_charges
707: Where standing_charge_id = l_trx.trx_sc_id
708: And generate_sequence = l_trx.trx_seq
709: ;
710: for line_rec in line_det ( l_trx.trx_sc_id ) loop