DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_GE_GEN_003

Line 61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

57: DECLARE
58: X_ROWID VARCHAR2(25);
59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.

Line 162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;

158: DECLARE
159: X_ROWID VARCHAR2(25);
160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.
165: -- Check if any of the non-primary key fields have been changed
166: -- and set the flag v_create_history to indicate so.

Line 268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

264: DECLARE
265: X_ROWID VARCHAR2(25);
266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.
271: -- Check if any of the non-primary key fields have been changed
272: -- and set the flag v_create_history to indicate so.

Line 393: l_n_org_id IGS_FI_FEE_AS_RT_H_ALL.org_id%TYPE := igs_ge_gen_003.get_org_id;

389: DECLARE
390: x_rowid VARCHAR2(25);
391: r_farh IGS_FI_FEE_AS_RT_H_ALL%ROWTYPE;
392: v_create_history BOOLEAN := FALSE;
393: l_n_org_id IGS_FI_FEE_AS_RT_H_ALL.org_id%TYPE := igs_ge_gen_003.get_org_id;
394: BEGIN
395: -- Create a history for a IGS_FI_FEE_AS_RATE record.
396: -- Check if any of the non-primary key fields have been changed
397: -- and set the flag v_create_history to indicate so.

Line 591: l_n_org_id IGS_FI_FEE_CAT_CI_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

587: DECLARE
588: X_ROWID VARCHAR2(25);
589: r_fccih IGS_FI_FEE_CAT_CI_HT%ROWTYPE;
590: v_create_history BOOLEAN := FALSE;
591: l_n_org_id IGS_FI_FEE_CAT_CI_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
592: BEGIN
593: -- Create a history for the IGS_FI_F_CAT_CA_INST table.
594: -- Check if any of the non-primary key fields have been changed
595: -- and set the flag v_create_history to indicate so.

Line 699: l_n_org_id IGS_FI_F_CAT_F_LBL_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

695: DECLARE
696: X_ROWID VARCHAR2(25);
697: r_fcflh IGS_FI_F_CAT_F_LBL_H%ROWTYPE;
698: v_create_history BOOLEAN := FALSE;
699: l_n_org_id IGS_FI_F_CAT_F_LBL_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
700: BEGIN
701: -- Create a history for a IGS_FI_F_CAT_FEE_LBL record.
702: -- Check if any of the non-primary key fields have been changed
703: -- and set the flag v_create_history to indicate so.

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 942: l_n_org_id IGS_FI_FEE_TYPE_CI_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

938: DECLARE
939: X_ROWID VARCHAR2(25);
940: r_ftcih IGS_FI_FEE_TYPE_CI_H%ROWTYPE;
941: v_create_history BOOLEAN := FALSE;
942: l_n_org_id IGS_FI_FEE_TYPE_CI_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
943: BEGIN
944: -- Check if any of the non-primary key fields have been changed
945: -- and set the flag v_create_history to indicate so.
946: IF p_new_fee_type_ci_status <> p_old_fee_type_ci_status THEN

Line 1080: l_n_org_id IGS_FI_FEE_TYPE_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;

1076: DECLARE
1077: X_ROWID VARCHAR2(25) := NULL;
1078: r_fth IGS_FI_FEE_TYPE_HIST%ROWTYPE;
1079: v_create_history BOOLEAN := FALSE;
1080: l_n_org_id IGS_FI_FEE_TYPE_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
1081: BEGIN
1082: -- Create a history for the IGS_FI_FEE_TYPE table.
1083: -- Check if any of the non-primary key fields have been changed
1084: -- and set the flag v_create_history to indicate so.

Line 1195: l_n_org_id IGS_FI_UNIT_FEE_TR_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

1191: DECLARE
1192: X_ROWID VARCHAR2(25);
1193: r_ufth IGS_FI_UNIT_FEE_TR_H%ROWTYPE;
1194: v_create_history BOOLEAN := FALSE;
1195: l_n_org_id IGS_FI_UNIT_FEE_TR_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
1196: BEGIN
1197: -- Create a history for a IGS_FI_UNIT_FEE_TRG record.
1198: -- Check if any of the non-primary key fields have been changed
1199: -- and set the flag v_create_history to indicate so.