eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_OR_GEN_001 dependencies on IGS_PE_HZ_PARTIES

Line 18: || Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

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.

Line 20: || Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg

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,

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 733: p_org_status igs_pe_hz_parties.ou_org_status%TYPE,

729: APP_EXCEPTION.RAISE_EXCEPTION;
730: END orgp_upd_ou_sts;
731:
732: PROCEDURE update_org(p_org_unit_cd hz_parties.party_number%TYPE,
733: p_org_status igs_pe_hz_parties.ou_org_status%TYPE,
734: p_end_date igs_pe_hz_parties.ou_end_dt%TYPE)
735: IS
736: /*
737: || Created By : pkpatel

Line 734: p_end_date igs_pe_hz_parties.ou_end_dt%TYPE)

730: END orgp_upd_ou_sts;
731:
732: PROCEDURE update_org(p_org_unit_cd hz_parties.party_number%TYPE,
733: p_org_status igs_pe_hz_parties.ou_org_status%TYPE,
734: p_end_date igs_pe_hz_parties.ou_end_dt%TYPE)
735: IS
736: /*
737: || Created By : pkpatel
738: || Created On : 10-DEC-2001

Line 747: || Modified signature of igs_pe_hz_parties_pkg to refer inst_priority_cd instead of inst_priority_code_id

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

Line 749: || and call to igs_pe_hz_parties_pkg.update_row

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);

Line 763: FROM hz_parties hp, igs_pe_hz_parties ihp

759:
760: CURSOR hz_parties_cur
761: IS
762: SELECT hp.*, ihp.oss_org_unit_cd
763: FROM hz_parties hp, igs_pe_hz_parties ihp
764: WHERE ihp.oss_org_unit_cd = p_org_unit_cd and
765: ihp.party_id = hp.party_id;
766:
767: CURSOR igs_org_cur(cp_party_id igs_pe_hz_parties.party_id%TYPE)

Line 767: CURSOR igs_org_cur(cp_party_id igs_pe_hz_parties.party_id%TYPE)

763: FROM hz_parties hp, igs_pe_hz_parties ihp
764: WHERE ihp.oss_org_unit_cd = p_org_unit_cd and
765: ihp.party_id = hp.party_id;
766:
767: CURSOR igs_org_cur(cp_party_id igs_pe_hz_parties.party_id%TYPE)
768: IS
769: SELECT rowid, pe.*
770: FROM igs_pe_hz_parties pe
771: WHERE party_id = cp_party_id

Line 770: FROM igs_pe_hz_parties pe

766:
767: CURSOR igs_org_cur(cp_party_id igs_pe_hz_parties.party_id%TYPE)
768: IS
769: SELECT rowid, pe.*
770: FROM igs_pe_hz_parties pe
771: WHERE party_id = cp_party_id
772: FOR UPDATE OF ou_end_dt, ou_org_status NOWAIT;
773:
774: hz_parties_rec hz_parties_cur%ROWTYPE;

Line 837: igs_pe_hz_parties_pkg.update_row (

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,