APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_STATS

Line 1126: l_inst_stat_id igs_or_inst_stats.inst_stat_id%TYPE;

1122: l_det_insert_success BOOLEAN;
1123: l_det_update_success BOOLEAN;
1124: l_det_dml_operation VARCHAR2(10);
1125: l_row_id ROWID;
1126: l_inst_stat_id igs_or_inst_stats.inst_stat_id%TYPE;
1127: l_det_row_id ROWID;
1128: l_dtl_id igs_or_inst_stat_dtl.inst_stat_dtl_id%TYPE;
1129: l_party_number hz_parties.party_number%TYPE;
1130:

Line 1153: FROM igs_or_inst_stats

1149: --Cursor to fetch the OSS Statistics Master Records for this Statistics Master Identifier
1150: --fetched from the Interface Table
1151: CURSOR cur_get_oss_stat_master(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,cp_party_id hz_parties.party_id%TYPE) IS
1152: SELECT *
1153: FROM igs_or_inst_stats
1154: WHERE stat_type_cd =p_stat_type_cd
1155: AND party_id =cp_party_id;
1156:
1157: --Cursor to fetch the OSS Statistics Detail Records to check against the recently

Line 1294: igs_or_inst_stats_pkg.insert_row(

1290: l_row_id :=NULL;
1291: OPEN c_val_stat(int_stat_master_rec.stat_type_cd,'OR_INST_STAT_TYPE','Y');
1292: FETCH c_val_stat INTO c_val_stat_rec;
1293: IF c_val_stat%FOUND THEN
1294: igs_or_inst_stats_pkg.insert_row(
1295: x_rowid =>l_row_id,
1296: x_inst_stat_id =>l_inst_stat_id,
1297: x_stat_type_cd =>int_stat_master_rec.stat_type_cd,
1298: x_party_id =>p_party_id,