APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_STAT_DTL

Line 1128: l_dtl_id igs_or_inst_stat_dtl.inst_stat_dtl_id%TYPE;

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:
1131: SKIP_STAT_MAST EXCEPTION;
1132:

Line 1159: CURSOR cur_get_oss_stat_det(p_int_stat_id igs_or_inst_stat_dtl.inst_stat_id%TYPE,

1155: AND party_id =cp_party_id;
1156:
1157: --Cursor to fetch the OSS Statistics Detail Records to check against the recently
1158: --inserted Detail record.
1159: CURSOR cur_get_oss_stat_det(p_int_stat_id igs_or_inst_stat_dtl.inst_stat_id%TYPE,
1160: p_year igs_or_inst_sdtl_int.year%TYPE) IS
1161: SELECT sdtl.rowid,sdtl.*
1162: FROM igs_or_inst_stat_dtl sdtl
1163: WHERE sdtl.inst_stat_id = p_int_stat_id

Line 1162: FROM igs_or_inst_stat_dtl sdtl

1158: --inserted Detail record.
1159: CURSOR cur_get_oss_stat_det(p_int_stat_id igs_or_inst_stat_dtl.inst_stat_id%TYPE,
1160: p_year igs_or_inst_sdtl_int.year%TYPE) IS
1161: SELECT sdtl.rowid,sdtl.*
1162: FROM igs_or_inst_stat_dtl sdtl
1163: WHERE sdtl.inst_stat_id = p_int_stat_id
1164: AND TO_CHAR(sdtl.year,'YYYY') = TO_CHAR(p_year,'YYYY');
1165:
1166: oss_stat_master_rec cur_get_oss_stat_master%ROWTYPE;

Line 1327: igs_or_inst_stat_dtl_pkg.insert_row(

1323: l_dtl_id:=NULL;
1324: l_det_row_id:=NULL;
1325:
1326: --Insert the Detail Record
1327: igs_or_inst_stat_dtl_pkg.insert_row(
1328: x_rowid => l_det_row_id,
1329: x_inst_stat_dtl_id => l_dtl_id,
1330: x_inst_stat_id => l_inst_stat_id,
1331: x_year => int_stat_det_rec.year ,

Line 1383: igs_or_inst_stat_dtl_pkg.insert_row(

1379: l_dtl_id:=NULL;
1380: l_det_row_id:=NULL;
1381: l_det_dml_operation:='INSERT';
1382: --Insert the Detail Record
1383: igs_or_inst_stat_dtl_pkg.insert_row(
1384: x_rowid => l_det_row_id,
1385: x_inst_stat_dtl_id => l_dtl_id,
1386: x_inst_stat_id => oss_stat_master_rec.inst_stat_id,
1387: x_year => int_stat_det_rec.year ,

Line 1395: igs_or_inst_stat_dtl_pkg.update_row(

1391: --Duplicate Detail Record is Found so update with the Interface Record Details
1392: ELSIF cur_get_oss_stat_det%FOUND THEN
1393: l_det_dml_operation:='UPDATE';
1394: --Update the Detail Record
1395: igs_or_inst_stat_dtl_pkg.update_row(
1396: x_rowid => oss_stat_det_rec.rowid,
1397: x_inst_stat_dtl_id => oss_stat_det_rec.inst_stat_dtl_id,
1398: x_inst_stat_id => oss_stat_det_rec.inst_stat_id,
1399: x_year => oss_stat_det_rec.year ,