APPS.IGS_FI_FUND_SRC_PKG dependencies on IGS_FI_FUND_SRC_HIST

Line 72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;

68: v_message_name varchar2(30);
69: v_description IGS_FI_FUND_SRC_ALL.description%TYPE;
70: v_govt_funding_source IGS_FI_FUND_SRC_ALL.govt_funding_source%TYPE;
71: v_closed_ind IGS_FI_FUND_SRC_ALL.closed_ind%TYPE;
72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
73: x_rowid VARCHAR2(25);
74: CURSOR SFFSH_CUR IS
75: SELECT Rowid
76: FROM IGS_FI_FUND_SRC_HIST

Line 76: FROM IGS_FI_FUND_SRC_HIST

72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
73: x_rowid VARCHAR2(25);
74: CURSOR SFFSH_CUR IS
75: SELECT Rowid
76: FROM IGS_FI_FUND_SRC_HIST
77: WHERE funding_source = old_references.funding_source;
78: BEGIN
79: -- Validate DEET funding source.
80: IF p_inserting OR

Line 106: IGS_FI_FUND_SRC_HIST_PKG.Insert_Row(

102: v_govt_funding_source,
103: v_closed_ind
104: FROM dual;
105: BEGIN
106: IGS_FI_FUND_SRC_HIST_PKG.Insert_Row(
107: X_ROWID => x_rowid,
108: X_FUNDING_SOURCE => old_references.funding_source,
109: X_HIST_START_DT => old_references.last_update_date,
110: X_HIST_END_DT => new_references.last_update_date,

Line 124: IGS_FI_FUND_SRC_HIST_PKG.Delete_Row(X_ROWID => SFFSH_Rec.Rowid);

120: -- Delete history records.
121: IF p_deleting THEN
122: FOR SFFSH_Rec in SFFSH_CUR
123: Loop
124: IGS_FI_FUND_SRC_HIST_PKG.Delete_Row(X_ROWID => SFFSH_Rec.Rowid);
125: End Loop;
126: END IF;
127: END BeforeRowInsertUpdateDelete1;
128: