DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_F_RET_SCHD_HT

Line 802: || and its references(if condition and from call IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW).

798: || Change History :
799: || Who When What
800: || (reverse chronological order - newest change first)
801: || vvutukur 19-Jul-2002 Bug#2425767.removed parameter p_new_deduction_amount,p_old_deduction_amount
802: || and its references(if condition and from call IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW).
803: ----------------------------------------------------------------------------*/
804: gv_other_detail VARCHAR2(255);
805: BEGIN
806: DECLARE

Line 808: r_frtnsh IGS_FI_F_RET_SCHD_HT%ROWTYPE;

804: gv_other_detail VARCHAR2(255);
805: BEGIN
806: DECLARE
807: X_ROWID VARCHAR2(25);
808: r_frtnsh IGS_FI_F_RET_SCHD_HT%ROWTYPE;
809: v_create_history BOOLEAN := FALSE;
810: l_n_org_id IGS_FI_F_RET_SCHD_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
811: BEGIN
812: -- Create a history for a IGS_FI_FEE_RET_SCHD record.

Line 810: l_n_org_id IGS_FI_F_RET_SCHD_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

806: DECLARE
807: X_ROWID VARCHAR2(25);
808: r_frtnsh IGS_FI_F_RET_SCHD_HT%ROWTYPE;
809: v_create_history BOOLEAN := FALSE;
810: l_n_org_id IGS_FI_F_RET_SCHD_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
811: BEGIN
812: -- Create a history for a IGS_FI_FEE_RET_SCHD record.
813: -- Check if any of the non-primary key fields have been changed
814: -- and set the flag v_create_history to indicate so.

Line 860: IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW(

856: r_frtnsh.sequence_number := p_sequence_number;
857: r_frtnsh.hist_start_dt := p_old_last_update_date;
858: r_frtnsh.hist_end_dt := p_new_last_update_date;
859: r_frtnsh.hist_who := p_old_last_updated_by;
860: IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW(
861: X_ROWID => X_ROWID,
862: X_fee_cal_type => r_frtnsh.fee_cal_type,
863: X_fee_ci_sequence_number => r_frtnsh.fee_ci_sequence_number,
864: X_s_relation_type => r_frtnsh.s_relation_type,