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.IGS_FI_UPG_RETENTION dependencies on GL_INTERFACE

Line 188: CURSOR c_gl_interface ( cp_v_ref_23 VARCHAR2, cp_v_ref_30 VARCHAR2) IS

184: FROM igs_fi_cr_activities crd
185: WHERE credit_id = cp_n_credit_id;
186: rec_cr_act_details c_cr_act_details%ROWTYPE;
187:
188: CURSOR c_gl_interface ( cp_v_ref_23 VARCHAR2, cp_v_ref_30 VARCHAR2) IS
189: SELECT rowid, accounted_cr, accounted_dr, code_combination_id
190: FROM gl_interface
191: WHERE reference23 = cp_v_ref_23
192: AND reference30 = cp_v_ref_30;

Line 190: FROM gl_interface

186: rec_cr_act_details c_cr_act_details%ROWTYPE;
187:
188: CURSOR c_gl_interface ( cp_v_ref_23 VARCHAR2, cp_v_ref_30 VARCHAR2) IS
189: SELECT rowid, accounted_cr, accounted_dr, code_combination_id
190: FROM gl_interface
191: WHERE reference23 = cp_v_ref_23
192: AND reference30 = cp_v_ref_30;
193:
194: CURSOR c_posting_int ( cp_n_source_tran_id NUMBER, cp_v_source_tran_type VARCHAR2) IS

Line 496: -- Check if this charge has been posted to GL Interface or Posting Interface

492: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rec_gl_ccid), l_v_upd_rec_account_cd) );
493: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_rev_gl_ccid), l_v_upd_rev_account_cd) );
494: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
495:
496: -- Check if this charge has been posted to GL Interface or Posting Interface
497: IF rec_invoice_details.posting_control_id IS NOT NULL THEN
498: IF l_v_rec_installed = 'Y' THEN
499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP
500:

Line 499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP

495:
496: -- Check if this charge has been posted to GL Interface or Posting Interface
497: IF rec_invoice_details.posting_control_id IS NOT NULL THEN
498: IF l_v_rec_installed = 'Y' THEN
499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP
500:
501: -- Update GL Interface with above derived accounting information
502: IF rec_gl_interface.accounted_dr IS NOT NULL
503: AND rec_gl_interface.code_combination_id IS NULL THEN

Line 501: -- Update GL Interface with above derived accounting information

497: IF rec_invoice_details.posting_control_id IS NOT NULL THEN
498: IF l_v_rec_installed = 'Y' THEN
499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP
500:
501: -- Update GL Interface with above derived accounting information
502: IF rec_gl_interface.accounted_dr IS NOT NULL
503: AND rec_gl_interface.code_combination_id IS NULL THEN
504:
505: UPDATE gl_interface

Line 502: IF rec_gl_interface.accounted_dr IS NOT NULL

498: IF l_v_rec_installed = 'Y' THEN
499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP
500:
501: -- Update GL Interface with above derived accounting information
502: IF rec_gl_interface.accounted_dr IS NOT NULL
503: AND rec_gl_interface.code_combination_id IS NULL THEN
504:
505: UPDATE gl_interface
506: SET code_combination_id = NVL(code_combination_id, l_n_upd_rec_gl_ccid)

Line 503: AND rec_gl_interface.code_combination_id IS NULL THEN

499: FOR rec_gl_interface IN c_gl_interface( rec_invoice_details.invoice_lines_id, 'IGS_FI_INVLN_INT' ) LOOP
500:
501: -- Update GL Interface with above derived accounting information
502: IF rec_gl_interface.accounted_dr IS NOT NULL
503: AND rec_gl_interface.code_combination_id IS NULL THEN
504:
505: UPDATE gl_interface
506: SET code_combination_id = NVL(code_combination_id, l_n_upd_rec_gl_ccid)
507: WHERE rowid = rec_gl_interface.rowid;

Line 505: UPDATE gl_interface

501: -- Update GL Interface with above derived accounting information
502: IF rec_gl_interface.accounted_dr IS NOT NULL
503: AND rec_gl_interface.code_combination_id IS NULL THEN
504:
505: UPDATE gl_interface
506: SET code_combination_id = NVL(code_combination_id, l_n_upd_rec_gl_ccid)
507: WHERE rowid = rec_gl_interface.rowid;
508: l_b_upgrade_done := TRUE;
509:

Line 507: WHERE rowid = rec_gl_interface.rowid;

503: AND rec_gl_interface.code_combination_id IS NULL THEN
504:
505: UPDATE gl_interface
506: SET code_combination_id = NVL(code_combination_id, l_n_upd_rec_gl_ccid)
507: WHERE rowid = rec_gl_interface.rowid;
508: l_b_upgrade_done := TRUE;
509:
510: ELSIF rec_gl_interface.accounted_cr IS NOT NULL
511: AND rec_gl_interface.code_combination_id IS NULL THEN

Line 510: ELSIF rec_gl_interface.accounted_cr IS NOT NULL

506: SET code_combination_id = NVL(code_combination_id, l_n_upd_rec_gl_ccid)
507: WHERE rowid = rec_gl_interface.rowid;
508: l_b_upgrade_done := TRUE;
509:
510: ELSIF rec_gl_interface.accounted_cr IS NOT NULL
511: AND rec_gl_interface.code_combination_id IS NULL THEN
512:
513: UPDATE gl_interface
514: SET code_combination_id = NVL(code_combination_id, l_n_upd_rev_gl_ccid)

Line 511: AND rec_gl_interface.code_combination_id IS NULL THEN

507: WHERE rowid = rec_gl_interface.rowid;
508: l_b_upgrade_done := TRUE;
509:
510: ELSIF rec_gl_interface.accounted_cr IS NOT NULL
511: AND rec_gl_interface.code_combination_id IS NULL THEN
512:
513: UPDATE gl_interface
514: SET code_combination_id = NVL(code_combination_id, l_n_upd_rev_gl_ccid)
515: WHERE rowid = rec_gl_interface.rowid;

Line 513: UPDATE gl_interface

509:
510: ELSIF rec_gl_interface.accounted_cr IS NOT NULL
511: AND rec_gl_interface.code_combination_id IS NULL THEN
512:
513: UPDATE gl_interface
514: SET code_combination_id = NVL(code_combination_id, l_n_upd_rev_gl_ccid)
515: WHERE rowid = rec_gl_interface.rowid;
516: l_b_upgrade_done := TRUE;
517:

Line 515: WHERE rowid = rec_gl_interface.rowid;

511: AND rec_gl_interface.code_combination_id IS NULL THEN
512:
513: UPDATE gl_interface
514: SET code_combination_id = NVL(code_combination_id, l_n_upd_rev_gl_ccid)
515: WHERE rowid = rec_gl_interface.rowid;
516: l_b_upgrade_done := TRUE;
517:
518: END IF;
519:

Line 620: -- Check if this Application Record has been posted to GL Interface or Posting Interface

616: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_application_details.dr_gl_code_ccid), rec_application_details.dr_account_cd) );
617: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_cr_gl_code_ccid), l_v_upd_cr_account_cd) );
618: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface
621: IF rec_application_details.posting_control_id IS NOT NULL THEN
622: IF l_v_rec_installed = 'Y' THEN
623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'

Line 623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP

619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface
621: IF rec_application_details.posting_control_id IS NOT NULL THEN
622: IF l_v_rec_installed = 'Y' THEN
623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'
625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface

Line 625: AND rec_gl_interface.accounted_cr IS NOT NULL

621: IF rec_application_details.posting_control_id IS NOT NULL THEN
622: IF l_v_rec_installed = 'Y' THEN
623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'
625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface
628: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
629: WHERE rowid = rec_gl_interface.rowid;

Line 626: AND rec_gl_interface.code_combination_id IS NULL THEN

622: IF l_v_rec_installed = 'Y' THEN
623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'
625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface
628: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
629: WHERE rowid = rec_gl_interface.rowid;
630: l_b_upgrade_done := TRUE;

Line 627: UPDATE gl_interface

623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'
625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface
628: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
629: WHERE rowid = rec_gl_interface.rowid;
630: l_b_upgrade_done := TRUE;
631:

Line 629: WHERE rowid = rec_gl_interface.rowid;

625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface
628: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
629: WHERE rowid = rec_gl_interface.rowid;
630: l_b_upgrade_done := TRUE;
631:
632: -- This code is executed for UNAPP Record transfered to GL.
633: ELSIF rec_application_details.application_type = 'UNAPP'

Line 634: AND rec_gl_interface.accounted_dr IS NOT NULL

630: l_b_upgrade_done := TRUE;
631:
632: -- This code is executed for UNAPP Record transfered to GL.
633: ELSIF rec_application_details.application_type = 'UNAPP'
634: AND rec_gl_interface.accounted_dr IS NOT NULL
635: AND rec_gl_interface.code_combination_id IS NULL THEN
636: UPDATE gl_interface
637: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
638: WHERE rowid = rec_gl_interface.rowid;

Line 635: AND rec_gl_interface.code_combination_id IS NULL THEN

631:
632: -- This code is executed for UNAPP Record transfered to GL.
633: ELSIF rec_application_details.application_type = 'UNAPP'
634: AND rec_gl_interface.accounted_dr IS NOT NULL
635: AND rec_gl_interface.code_combination_id IS NULL THEN
636: UPDATE gl_interface
637: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
638: WHERE rowid = rec_gl_interface.rowid;
639: l_b_upgrade_done := TRUE;

Line 636: UPDATE gl_interface

632: -- This code is executed for UNAPP Record transfered to GL.
633: ELSIF rec_application_details.application_type = 'UNAPP'
634: AND rec_gl_interface.accounted_dr IS NOT NULL
635: AND rec_gl_interface.code_combination_id IS NULL THEN
636: UPDATE gl_interface
637: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
638: WHERE rowid = rec_gl_interface.rowid;
639: l_b_upgrade_done := TRUE;
640: END IF;

Line 638: WHERE rowid = rec_gl_interface.rowid;

634: AND rec_gl_interface.accounted_dr IS NOT NULL
635: AND rec_gl_interface.code_combination_id IS NULL THEN
636: UPDATE gl_interface
637: SET code_combination_id = NVL(code_combination_id, l_n_upd_cr_gl_code_ccid)
638: WHERE rowid = rec_gl_interface.rowid;
639: l_b_upgrade_done := TRUE;
640: END IF;
641: END LOOP;
642:

Line 727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface

723: fnd_file.put_line(fnd_file.LOG, l_v_lkp_dr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(l_n_upd_dr_gl_ccid), l_v_upd_dr_account_cd) );
724: fnd_file.put_line(fnd_file.LOG, l_v_lkp_cr_account || ': ' || NVL(igs_fi_gen_007.get_ccid_concat(rec_cr_act_details.cr_gl_ccid), rec_cr_act_details.cr_account_cd) );
725: fnd_file.put_line(fnd_file.LOG, l_v_lkp_status || ' : ' || l_v_lkp_success );
726:
727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface
728: IF rec_cr_act_details.posting_control_id IS NOT NULL THEN
729: IF l_v_rec_installed = 'Y' THEN
730:
731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP

Line 731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP

727: -- Check if this Credit Activity Record has been posted to GL Interface or Posting Interface
728: IF rec_cr_act_details.posting_control_id IS NOT NULL THEN
729: IF l_v_rec_installed = 'Y' THEN
730:
731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP
732: IF rec_gl_interface.accounted_dr IS NOT NULL
733: AND rec_gl_interface.code_combination_id IS NULL THEN
734: UPDATE gl_interface
735: SET code_combination_id = NVL(code_combination_id, l_n_upd_dr_gl_ccid)

Line 732: IF rec_gl_interface.accounted_dr IS NOT NULL

728: IF rec_cr_act_details.posting_control_id IS NOT NULL THEN
729: IF l_v_rec_installed = 'Y' THEN
730:
731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP
732: IF rec_gl_interface.accounted_dr IS NOT NULL
733: AND rec_gl_interface.code_combination_id IS NULL THEN
734: UPDATE gl_interface
735: SET code_combination_id = NVL(code_combination_id, l_n_upd_dr_gl_ccid)
736: WHERE rowid = rec_gl_interface.rowid;

Line 733: AND rec_gl_interface.code_combination_id IS NULL THEN

729: IF l_v_rec_installed = 'Y' THEN
730:
731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP
732: IF rec_gl_interface.accounted_dr IS NOT NULL
733: AND rec_gl_interface.code_combination_id IS NULL THEN
734: UPDATE gl_interface
735: SET code_combination_id = NVL(code_combination_id, l_n_upd_dr_gl_ccid)
736: WHERE rowid = rec_gl_interface.rowid;
737: l_b_upgrade_done := TRUE;

Line 734: UPDATE gl_interface

730:
731: FOR rec_gl_interface IN c_gl_interface( rec_cr_act_details.credit_activity_id, 'IGS_FI_CR_ACTIVITIES' ) LOOP
732: IF rec_gl_interface.accounted_dr IS NOT NULL
733: AND rec_gl_interface.code_combination_id IS NULL THEN
734: UPDATE gl_interface
735: SET code_combination_id = NVL(code_combination_id, l_n_upd_dr_gl_ccid)
736: WHERE rowid = rec_gl_interface.rowid;
737: l_b_upgrade_done := TRUE;
738: END IF;

Line 736: WHERE rowid = rec_gl_interface.rowid;

732: IF rec_gl_interface.accounted_dr IS NOT NULL
733: AND rec_gl_interface.code_combination_id IS NULL THEN
734: UPDATE gl_interface
735: SET code_combination_id = NVL(code_combination_id, l_n_upd_dr_gl_ccid)
736: WHERE rowid = rec_gl_interface.rowid;
737: l_b_upgrade_done := TRUE;
738: END IF;
739: END LOOP;
740: