APPS.IGS_OR_GEN_001 dependencies on 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 24: || mmkumar 18-Jul-2005 Party_Number impact, inside update_org , modified cursor hz_parties_cur,

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,
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(

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 309: TYPE t_temp_table IS TABLE OF hz_parties.party_number%TYPE

305: v_message_name VARCHAR2(30);
306: v_active_parent_exists BOOLEAN := FALSE;
307:
308: -- Define a PL/SQL table to hold the Org Unit Code that are already processed
309: TYPE t_temp_table IS TABLE OF hz_parties.party_number%TYPE
310: INDEX BY BINARY_INTEGER;
311:
312: temp_table t_temp_table;
313: l_index binary_integer := 0;

Line 732: PROCEDURE update_org(p_org_unit_cd hz_parties.party_number%TYPE,

728: IGS_GE_MSG_STACK.ADD;
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: /*

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 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 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 760: CURSOR hz_parties_cur

756: l_org_id VARCHAR2(25);
757: l_hist_start_dt DATE;
758: l_hist_end_dt DATE;
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

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 774: hz_parties_rec hz_parties_cur%ROWTYPE;

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;
775: igs_org_rec igs_org_cur%ROWTYPE;
776:
777: BEGIN
778:

Line 779: OPEN hz_parties_cur;

775: igs_org_rec igs_org_cur%ROWTYPE;
776:
777: BEGIN
778:
779: OPEN hz_parties_cur;
780: FETCH hz_parties_cur INTO hz_parties_rec;
781: CLOSE hz_parties_cur;
782:
783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to

Line 780: FETCH hz_parties_cur INTO hz_parties_rec;

776:
777: BEGIN
778:
779: OPEN hz_parties_cur;
780: FETCH hz_parties_cur INTO hz_parties_rec;
781: CLOSE hz_parties_cur;
782:
783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to
784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.

Line 781: CLOSE hz_parties_cur;

777: BEGIN
778:
779: OPEN hz_parties_cur;
780: FETCH hz_parties_cur INTO hz_parties_rec;
781: CLOSE hz_parties_cur;
782:
783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to
784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.
785: -- This call is made so that the last update date is refreshed and the History would show the proper Start and End Date.

Line 783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to

779: OPEN hz_parties_cur;
780: FETCH hz_parties_cur INTO hz_parties_rec;
781: CLOSE hz_parties_cur;
782:
783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to
784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.
785: -- This call is made so that the last update date is refreshed and the History would show the proper Start and End Date.
786:
787: igs_or_gen_012_pkg.update_organization (

Line 784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.

780: FETCH hz_parties_cur INTO hz_parties_rec;
781: CLOSE hz_parties_cur;
782:
783: -- The Record in HZ_PARTIES was still updated with STATUS 'A'(Active), since it was decided not to
784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.
785: -- This call is made so that the last update date is refreshed and the History would show the proper Start and End Date.
786:
787: igs_or_gen_012_pkg.update_organization (
788: p_party_id => hz_parties_rec.party_id,

Line 788: p_party_id => hz_parties_rec.party_id,

784: -- touch the record in HZ_PARTIES since other products may also be using this TCA record.
785: -- This call is made so that the last update date is refreshed and the History would show the proper Start and End Date.
786:
787: igs_or_gen_012_pkg.update_organization (
788: p_party_id => hz_parties_rec.party_id,
789: p_institution_cd => hz_parties_rec.party_number,
790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,

Line 789: p_institution_cd => hz_parties_rec.party_number,

785: -- This call is made so that the last update date is refreshed and the History would show the proper Start and End Date.
786:
787: igs_or_gen_012_pkg.update_organization (
788: p_party_id => hz_parties_rec.party_id,
789: p_institution_cd => hz_parties_rec.party_number,
790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,

Line 790: p_name => hz_parties_rec.party_name,

786:
787: igs_or_gen_012_pkg.update_organization (
788: p_party_id => hz_parties_rec.party_id,
789: p_institution_cd => hz_parties_rec.party_number,
790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,

Line 792: p_last_update => hz_parties_rec.last_update_date,

788: p_party_id => hz_parties_rec.party_id,
789: p_institution_cd => hz_parties_rec.party_number,
790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,

Line 793: p_attribute_category => hz_parties_rec.attribute_category,

789: p_institution_cd => hz_parties_rec.party_number,
790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,

Line 794: p_attribute1 => hz_parties_rec.attribute1,

790: p_name => hz_parties_rec.party_name,
791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,

Line 795: p_attribute2 => hz_parties_rec.attribute2,

791: p_status => 'A',
792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,

Line 796: p_attribute3 => hz_parties_rec.attribute3,

792: p_last_update => hz_parties_rec.last_update_date,
793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,

Line 797: p_attribute4 => hz_parties_rec.attribute4,

793: p_attribute_category => hz_parties_rec.attribute_category,
794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,

Line 798: p_attribute5 => hz_parties_rec.attribute5,

794: p_attribute1 => hz_parties_rec.attribute1,
795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,

Line 799: p_attribute6 => hz_parties_rec.attribute6,

795: p_attribute2 => hz_parties_rec.attribute2,
796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,

Line 800: p_attribute7 => hz_parties_rec.attribute7,

796: p_attribute3 => hz_parties_rec.attribute3,
797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,

Line 801: p_attribute8 => hz_parties_rec.attribute8,

797: p_attribute4 => hz_parties_rec.attribute4,
798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,

Line 802: p_attribute9 => hz_parties_rec.attribute9,

798: p_attribute5 => hz_parties_rec.attribute5,
799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,

Line 803: p_attribute10 => hz_parties_rec.attribute10,

799: p_attribute6 => hz_parties_rec.attribute6,
800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,

Line 804: p_attribute11 => hz_parties_rec.attribute11,

800: p_attribute7 => hz_parties_rec.attribute7,
801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,

Line 805: p_attribute12 => hz_parties_rec.attribute12,

801: p_attribute8 => hz_parties_rec.attribute8,
802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,

Line 806: p_attribute13 => hz_parties_rec.attribute13,

802: p_attribute9 => hz_parties_rec.attribute9,
803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,

Line 807: p_attribute14 => hz_parties_rec.attribute14,

803: p_attribute10 => hz_parties_rec.attribute10,
804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,

Line 808: p_attribute15 => hz_parties_rec.attribute15,

804: p_attribute11 => hz_parties_rec.attribute11,
805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,

Line 809: p_attribute16 => hz_parties_rec.attribute16,

805: p_attribute12 => hz_parties_rec.attribute12,
806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,

Line 810: p_attribute17 => hz_parties_rec.attribute17,

806: p_attribute13 => hz_parties_rec.attribute13,
807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,

Line 811: p_attribute18 => hz_parties_rec.attribute18,

807: p_attribute14 => hz_parties_rec.attribute14,
808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,

Line 812: p_attribute19 => hz_parties_rec.attribute19,

808: p_attribute15 => hz_parties_rec.attribute15,
809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,

Line 813: p_attribute20 => hz_parties_rec.attribute20,

809: p_attribute16 => hz_parties_rec.attribute16,
810: p_attribute17 => hz_parties_rec.attribute17,
811: p_attribute18 => hz_parties_rec.attribute18,
812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,

Line 816: p_object_version_number => hz_parties_rec.object_version_number,

812: p_attribute19 => hz_parties_rec.attribute19,
813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,
818: p_attribute22 => hz_parties_rec.attribute22,
819: p_attribute23 => hz_parties_rec.attribute23,
820: p_attribute24 => hz_parties_rec.attribute24

Line 817: p_attribute21 => hz_parties_rec.attribute21,

813: p_attribute20 => hz_parties_rec.attribute20,
814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,
818: p_attribute22 => hz_parties_rec.attribute22,
819: p_attribute23 => hz_parties_rec.attribute23,
820: p_attribute24 => hz_parties_rec.attribute24
821: ) ;

Line 818: p_attribute22 => hz_parties_rec.attribute22,

814: p_return_status => l_return_status,
815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,
818: p_attribute22 => hz_parties_rec.attribute22,
819: p_attribute23 => hz_parties_rec.attribute23,
820: p_attribute24 => hz_parties_rec.attribute24
821: ) ;
822:

Line 819: p_attribute23 => hz_parties_rec.attribute23,

815: p_msg_data => l_msg_data,
816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,
818: p_attribute22 => hz_parties_rec.attribute22,
819: p_attribute23 => hz_parties_rec.attribute23,
820: p_attribute24 => hz_parties_rec.attribute24
821: ) ;
822:
823:

Line 820: p_attribute24 => hz_parties_rec.attribute24

816: p_object_version_number => hz_parties_rec.object_version_number,
817: p_attribute21 => hz_parties_rec.attribute21,
818: p_attribute22 => hz_parties_rec.attribute22,
819: p_attribute23 => hz_parties_rec.attribute23,
820: p_attribute24 => hz_parties_rec.attribute24
821: ) ;
822:
823:
824: IF l_return_status = 'S' THEN

Line 827: OPEN igs_org_cur(hz_parties_rec.party_id);

823:
824: IF l_return_status = 'S' THEN
825:
826: -- To check whether the Record is locked.
827: OPEN igs_org_cur(hz_parties_rec.party_id);
828: FETCH igs_org_cur INTO igs_org_rec;
829: IF igs_org_cur%NOTFOUND THEN
830: CLOSE igs_org_cur;
831: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

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,

Line 879: x_oss_org_unit_cd => hz_parties_rec.oss_org_unit_cd --mmkumar , party_number impact

875: x_fund_authorization => igs_org_rec.fund_authorization,
876: x_pe_info_verify_time => igs_org_rec.pe_info_verify_time,
877: x_birth_city => igs_org_rec.birth_city,
878: x_birth_country => igs_org_rec.birth_country,
879: x_oss_org_unit_cd => hz_parties_rec.oss_org_unit_cd --mmkumar , party_number impact
880:
881: );
882:
883: l_org_id := igs_ge_gen_003.get_org_id ;

Line 886: l_hist_start_dt := hz_parties_rec.last_update_date - 1/(60*24*60);

882:
883: l_org_id := igs_ge_gen_003.get_org_id ;
884:
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,

Line 891: X_ORG_UNIT_CD => hz_parties_rec.oss_org_unit_cd,

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,
894: X_HIST_END_DT => l_hist_end_dt,
895: X_HIST_WHO => hz_parties_rec.last_updated_by,

Line 895: X_HIST_WHO => hz_parties_rec.last_updated_by,

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,
894: X_HIST_END_DT => l_hist_end_dt,
895: X_HIST_WHO => hz_parties_rec.last_updated_by,
896: X_OU_END_DT => igs_org_rec.ou_end_dt,
897: X_DESCRIPTION => hz_parties_rec.party_name,
898: X_ORG_STATUS => igs_org_rec.ou_org_status,
899: X_ORG_TYPE => igs_org_rec.ou_org_type,

Line 897: X_DESCRIPTION => hz_parties_rec.party_name,

893: X_HIST_START_DT => l_hist_start_dt,
894: X_HIST_END_DT => l_hist_end_dt,
895: X_HIST_WHO => hz_parties_rec.last_updated_by,
896: X_OU_END_DT => igs_org_rec.ou_end_dt,
897: X_DESCRIPTION => hz_parties_rec.party_name,
898: X_ORG_STATUS => igs_org_rec.ou_org_status,
899: X_ORG_TYPE => igs_org_rec.ou_org_type,
900: X_MEMBER_TYPE => igs_org_rec.ou_member_type,
901: X_INSTITUTION_CD => igs_org_rec.institution_cd,