[Home] [Help]
14: || orgp_upd_ou_sts to propagate the STATUS through Organizational Structure.
15: || ssawhney 11-jun-2002 BUG : 2408794
16: || ORGP_GET_WITHIN_OU, c_our cursor added check for LOGICAL_DELETE_DT IS NULL;
17: || pkpatel 25-OCT-2002 Bug No: 2613704
18: || Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
19: || pkpatel 2-DEC-2002 Bug No: 2599109
20: || Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
21: || ssawhney 30-apr-2003 V2API OVN implementation, change to call to IGS_OR_GEN_012
22: || gmaheswa 15-sep-2003 changed orgp_get_local_inst to get local active institution from the profile.
16: || ORGP_GET_WITHIN_OU, c_our cursor added check for LOGICAL_DELETE_DT IS NULL;
17: || pkpatel 25-OCT-2002 Bug No: 2613704
18: || Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
19: || pkpatel 2-DEC-2002 Bug No: 2599109
20: || Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
21: || ssawhney 30-apr-2003 V2API OVN implementation, change to call to IGS_OR_GEN_012
22: || gmaheswa 15-sep-2003 changed orgp_get_local_inst to get local active institution from the profile.
23: || Bug No: 2863933
24: || mmkumar 18-Jul-2005 Party_Number impact, inside update_org , modified cursor hz_parties_cur,
21: || ssawhney 30-apr-2003 V2API OVN implementation, change to call to IGS_OR_GEN_012
22: || gmaheswa 15-sep-2003 changed orgp_get_local_inst to get local active institution from the profile.
23: || Bug No: 2863933
24: || mmkumar 18-Jul-2005 Party_Number impact, inside update_org , modified cursor hz_parties_cur,
25: || igs_or_unit_hist_pkg.insert_row call and call to igs_pe_hz_parties_pkg.update_row
26: */
27:
28: PROCEDURE orgp_del_instn_hist(
29: p_institution_cd IN VARCHAR2 )
743: || Who When What
744: || skpandey 27-SEP-2005 Bug: 3663505
745: || Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
746: || pkpatel 25-OCT-2002 Bug No: 2613704
747: || Modified signature of igs_pe_hz_parties_pkg to refer inst_priority_cd instead of inst_priority_code_id
748: || mmkumar 18-Jul-2005 Party_Number impact, modified cursor hz_parties_cur, igs_or_unit_hist_pkg.insert_row call
749: || and call to igs_pe_hz_parties_pkg.update_row
750: || (reverse chronological order - newest change first)
751: */
745: || Description: Added ATTRIBUTES 21 TO 24 to store additional information in IGS_OR_GEN_012_PKG call
746: || pkpatel 25-OCT-2002 Bug No: 2613704
747: || Modified signature of igs_pe_hz_parties_pkg to refer inst_priority_cd instead of inst_priority_code_id
748: || mmkumar 18-Jul-2005 Party_Number impact, modified cursor hz_parties_cur, igs_or_unit_hist_pkg.insert_row call
749: || and call to igs_pe_hz_parties_pkg.update_row
750: || (reverse chronological order - newest change first)
751: */
752:
753: l_return_status VARCHAR2(1);
833: APP_EXCEPTION.RAISE_EXCEPTION;
834: END IF;
835: CLOSE igs_org_cur;
836:
837: igs_pe_hz_parties_pkg.update_row (
838: x_mode => 'R',
839: x_rowid => igs_org_rec.rowid,
840: x_party_id => igs_org_rec.party_id,
841: x_deceased_ind => igs_org_rec.deceased_ind,