APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_STAT_INT

Line 1102: p_interface_id IN igs_or_inst_stat_int.interface_id%TYPE,

1098: END process_institution_contacts;
1099:
1100: --Procedure to Upload the Institution Statistics
1101: PROCEDURE process_institution_statistics (
1102: p_interface_id IN igs_or_inst_stat_int.interface_id%TYPE,
1103: p_party_id IN hz_parties.party_id%TYPE)
1104: /***************************************************************
1105: Created By : mesriniv
1106: Date Created By : 2001/07/12

Line 1134: CURSOR cur_get_int_stat_master(cp_interface_id igs_or_inst_stat_int.interface_id%TYPE,

1130:
1131: SKIP_STAT_MAST EXCEPTION;
1132:
1133: --Cursor to fetch the Interface Statistics Master Records for the Interface Identifier
1134: CURSOR cur_get_int_stat_master(cp_interface_id igs_or_inst_stat_int.interface_id%TYPE,
1135: cp_status igs_or_inst_stat_int.status%TYPE) IS
1136: SELECT *
1137: FROM igs_or_inst_stat_int
1138: WHERE interface_id =cp_interface_id

Line 1135: cp_status igs_or_inst_stat_int.status%TYPE) IS

1131: SKIP_STAT_MAST EXCEPTION;
1132:
1133: --Cursor to fetch the Interface Statistics Master Records for the Interface Identifier
1134: CURSOR cur_get_int_stat_master(cp_interface_id igs_or_inst_stat_int.interface_id%TYPE,
1135: cp_status igs_or_inst_stat_int.status%TYPE) IS
1136: SELECT *
1137: FROM igs_or_inst_stat_int
1138: WHERE interface_id =cp_interface_id
1139: AND status =cp_status ;

Line 1137: FROM igs_or_inst_stat_int

1133: --Cursor to fetch the Interface Statistics Master Records for the Interface Identifier
1134: CURSOR cur_get_int_stat_master(cp_interface_id igs_or_inst_stat_int.interface_id%TYPE,
1135: cp_status igs_or_inst_stat_int.status%TYPE) IS
1136: SELECT *
1137: FROM igs_or_inst_stat_int
1138: WHERE interface_id =cp_interface_id
1139: AND status =cp_status ;
1140:
1141: --Cursor to fetch the Interface Statistics Detail Records for this Statistics master record

Line 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

1147: AND status = cp_status;
1148:
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;

Line 1170: CURSOR c_val_stat(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,

1166: oss_stat_master_rec cur_get_oss_stat_master%ROWTYPE;
1167: oss_stat_det_rec cur_get_oss_stat_det%ROWTYPE;
1168:
1169: --cursor to do field level validation before importing data into statistics master
1170: CURSOR c_val_stat(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,
1171: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
1172: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
1173: SELECT 'X'
1174: FROM igs_lookup_values lkv

Line 1182: PROCEDURE update_int_stat(p_int_stat_rec igs_or_inst_stat_int%ROWTYPE)

1178:
1179: c_val_stat_rec c_val_stat%ROWTYPE;
1180:
1181: --Procedure to update the Statistics Master Interface Table
1182: PROCEDURE update_int_stat(p_int_stat_rec igs_or_inst_stat_int%ROWTYPE)
1183: AS
1184:
1185: BEGIN
1186:

Line 1187: UPDATE igs_or_inst_stat_int

1183: AS
1184:
1185: BEGIN
1186:
1187: UPDATE igs_or_inst_stat_int
1188: SET status = p_int_stat_rec.status,
1189: error_code =p_int_stat_rec.error_code
1190: WHERE interface_inst_stat_id =p_int_stat_rec.interface_inst_stat_id;
1191:

Line 1235: PROCEDURE display_error(p_int_stat_master_rec IN OUT NOCOPY igs_or_inst_stat_int%ROWTYPE,

1231:
1232: END update_int_stat_det;
1233:
1234: --Procedure to display the error in when others exception
1235: PROCEDURE display_error(p_int_stat_master_rec IN OUT NOCOPY igs_or_inst_stat_int%ROWTYPE,
1236: p_int_stat_det_rec IN OUT NOCOPY cur_get_int_stat_det%ROWTYPE
1237: )
1238: AS
1239: