APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_CR_ACTIVITIES

Line 184: FROM igs_fi_cr_activities crd

180: WHERE invoice_id = cp_n_invoice_id;
181:
182: CURSOR c_cr_act_details ( cp_n_credit_id igs_fi_credits_all.credit_id%TYPE ) IS
183: SELECT ROWID, crd.*
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

Line 702: igs_fi_cr_activities_pkg.update_row(x_rowid => rec_cr_act_details.rowid,

698: END IF;
699:
700: IF l_b_upd = TRUE THEN
701: l_b_upgrade_done := TRUE;
702: igs_fi_cr_activities_pkg.update_row(x_rowid => rec_cr_act_details.rowid,
703: x_credit_activity_id => rec_cr_act_details.credit_activity_id,
704: x_credit_id => rec_cr_act_details.credit_id,
705: x_status => rec_cr_act_details.status,
706: x_transaction_date => rec_cr_act_details.transaction_date,

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)