APPS.IGS_PE_PERSON_SS_PKG dependencies on HZ_PARTY_SITE_USES

Line 810: l_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE := p_party_site_use_id;

806: IS
807: l_api_name CONSTANT VARCHAR2(30) := 'Update_Usage';
808: l_api_version CONSTANT NUMBER := 1.0;
809: l_rowid VARCHAR2(255);
810: l_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE := p_party_site_use_id;
811: l_party_site_id hz_party_site_uses.party_site_id%TYPE := p_party_site_id;
812: l_site_use_id igs_pe_partysiteuse_v.site_use_id%TYPE := p_site_use_id;
813: l_date DATE :=sysdate;
814: l_return_status VARCHAR2(1);

Line 811: l_party_site_id hz_party_site_uses.party_site_id%TYPE := p_party_site_id;

807: l_api_name CONSTANT VARCHAR2(30) := 'Update_Usage';
808: l_api_version CONSTANT NUMBER := 1.0;
809: l_rowid VARCHAR2(255);
810: l_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE := p_party_site_use_id;
811: l_party_site_id hz_party_site_uses.party_site_id%TYPE := p_party_site_id;
812: l_site_use_id igs_pe_partysiteuse_v.site_use_id%TYPE := p_site_use_id;
813: l_date DATE :=sysdate;
814: l_return_status VARCHAR2(1);
815: l_msg_count NUMBER;

Line 819: CURSOR dup_addrs_cur(cp_site_use_type hz_party_site_uses.site_use_type%TYPE,

815: l_msg_count NUMBER;
816: l_msg_data VARCHAR(2000);
817: l_mode VARCHAR(10);
818:
819: CURSOR dup_addrs_cur(cp_site_use_type hz_party_site_uses.site_use_type%TYPE,
820: cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
821: cp_status hz_party_site_uses.status%TYPE
822: )IS
823:

Line 820: cp_party_site_id hz_party_site_uses.party_site_id%TYPE,

816: l_msg_data VARCHAR(2000);
817: l_mode VARCHAR(10);
818:
819: CURSOR dup_addrs_cur(cp_site_use_type hz_party_site_uses.site_use_type%TYPE,
820: cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
821: cp_status hz_party_site_uses.status%TYPE
822: )IS
823:
824: SELECT party_site_use_id, object_version_number

Line 821: cp_status hz_party_site_uses.status%TYPE

817: l_mode VARCHAR(10);
818:
819: CURSOR dup_addrs_cur(cp_site_use_type hz_party_site_uses.site_use_type%TYPE,
820: cp_party_site_id hz_party_site_uses.party_site_id%TYPE,
821: cp_status hz_party_site_uses.status%TYPE
822: )IS
823:
824: SELECT party_site_use_id, object_version_number
825: FROM HZ_PARTY_SITE_USES

Line 825: FROM HZ_PARTY_SITE_USES

821: cp_status hz_party_site_uses.status%TYPE
822: )IS
823:
824: SELECT party_site_use_id, object_version_number
825: FROM HZ_PARTY_SITE_USES
826: WHERE site_use_type = cp_site_use_type AND
827: party_site_id = cp_party_site_id AND
828: status = cp_status;
829:

Line 854: -- Call IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK procedure

850: FND_MSG_PUB.initialize;
851:
852: -- API body
853: -- Retrieve current row values to be passed to the procedure.
854: -- Call IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK procedure
855:
856: l_mode:= p_mode;
857:
858: IF p_mode='INSERT' THEN

Line 871: igs_pe_party_site_use_pkg.hz_party_site_uses_ak(

867: p_hz_party_site_use_ovn := dup_addrs_rec.object_version_number;
868: END IF;
869: END IF;
870:
871: igs_pe_party_site_use_pkg.hz_party_site_uses_ak(
872: p_action => l_mode,
873: p_rowid => l_rowid,
874: p_party_site_use_id => l_party_site_use_id,
875: p_party_site_id => l_party_site_id,

Line 2357: FROM hz_party_site_uses hps

2353: AND hps.party_site_id = ihps.party_site_id(+);
2354:
2355: CURSOR c_site_detail (cp_party_site_id NUMBER) IS
2356: SELECT site_use_type
2357: FROM hz_party_site_uses hps
2358: WHERE hps.party_site_id = cp_party_site_id;
2359:
2360: CURSOR c_subject_party_name (cp_subject_id NUMBER) IS
2361: SELECT party_name

Line 2590: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

2586:
2587: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)
2588: LOOP
2589: l_party_site_use_id := NULL;
2590: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
2591: p_action => 'INSERT',
2592: p_rowid => l_party_site_use_rowid,
2593: p_party_site_use_id => l_party_site_use_id,
2594: p_party_site_id => l_party_site_id,

Line 2908: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

2904:
2905: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)
2906: LOOP
2907: l_party_site_use_id := NULL;
2908: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
2909: p_action => 'INSERT',
2910: p_rowid => l_party_site_use_rowid,
2911: p_party_site_use_id => l_party_site_use_id,
2912: p_party_site_id => l_party_site_id,