DBA Data[Home] [Help]

APPS.IGS_OR_GEN_001 dependencies on IGS_OR_UNIT_HIST_PKG

Line 25: || igs_or_unit_hist_pkg.insert_row call and call to igs_pe_hz_parties_pkg.update_row

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 )

Line 748: || mmkumar 18-Jul-2005 Party_Number impact, modified cursor hz_parties_cur, igs_or_unit_hist_pkg.insert_row call

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: */
752:

Line 889: igs_or_unit_hist_pkg.insert_row (

885: -- 1 Second is deducted, to prevent the PK validation. The Hisory Start Date is part of PK.
886: l_hist_start_dt := hz_parties_rec.last_update_date - 1/(60*24*60);
887: l_hist_end_dt := SYSDATE;
888:
889: igs_or_unit_hist_pkg.insert_row (
890: X_ROWID => lv_rowid,
891: X_ORG_UNIT_CD => hz_parties_rec.oss_org_unit_cd,
892: X_OU_START_DT => igs_org_rec.ou_start_dt,
893: X_HIST_START_DT => l_hist_start_dt,