DBA Data[Home] [Help]

APPS.AMS_PARTYIMPORT_PVT dependencies on HZ_PARTIES

Line 3475: p_table_name => 'HZ_PARTIES',

3471: --
3472: -- PARTY_ID
3473: IF p_party_rec.party_id <> FND_API.g_miss_num THEN
3474: IF AMS_Utility_PVT.check_fk_exists (
3475: p_table_name => 'HZ_PARTIES',
3476: p_pk_name => 'PARTY_ID',
3477: p_pk_value => p_party_rec.party_id,
3478: p_pk_data_type => AMS_Utility_PVT.g_number
3479: ) = FND_API.g_false THEN

Line 3637: -- Synchronize the ID's in HZ_PARTIES with those

3633: -- Initialize the dedupe table.
3634: Initialize_Dedupe_Table;
3635:
3636: --
3637: -- Synchronize the ID's in HZ_PARTIES with those
3638: -- in the dedupe table.
3639: Synchronize_ID;
3640:
3641: --

Line 3682: -- that of HZ_PARTIES.

3678: -- PROCEDURE
3679: -- Synchronize_ID
3680: -- PURPOSE
3681: -- Synchronize the PARTY_ID of AMS_PARTY_DEDUPE with
3682: -- that of HZ_PARTIES.
3683: -- HISTORY
3684: -- 11-Nov-1999 choang Created.
3685: -----------------------------------------------------------
3686: PROCEDURE Synchronize_ID

Line 3705: FROM hz_parties

3701: SYSDATE, -- creation_date
3702: FND_GLOBAL.user_id, -- created_by
3703: FND_GLOBAL.conc_login_id, -- last_update_login
3704: 1 -- object_version_number
3705: FROM hz_parties
3706: ;
3707: END Synchronize_ID;
3708:
3709:

Line 3798: -- in hz_parties because imported data was only being fetched

3794: -- Process_Party
3795: -- HISTORY
3796: -- 13-Nov-1999 choang Created.
3797: -- 27-Feb-2000 choang Party sources were not being created for existing persons
3798: -- in hz_parties because imported data was only being fetched
3799: -- for new party sources. Moved the imported data fetch to
3800: -- the initialization area of the API.
3801: -----------------------------------------------------------
3802: PROCEDURE Process_Party (

Line 3942: -- Does the party exist in HZ_PARTIES?

3938: x_dedupe_key => l_dedupe_key
3939: );
3940:
3941: --
3942: -- Does the party exist in HZ_PARTIES?
3943: IF Party_Exists (l_dedupe_key, l_party_id) THEN
3944: l_party_sources_rec.overlay_flag := 'Y';
3945: l_party_sources_rec.overlay_date := SYSDATE;
3946: ELSE

Line 3950: -- Create the record in HZ_PARTIES

3946: ELSE
3947: l_party_sources_rec.overlay_flag := 'N';
3948: -- Begin change - ryedator - for R12 compilation issues.
3949: /*
3950: -- Create the record in HZ_PARTIES
3951: l_person_rec.first_name := l_import_rec.COL1;
3952: l_person_rec.last_name := l_import_rec.COL2;
3953: l_person_rec.title := l_import_rec.COL3;
3954: HZ_Party_Pub.Create_Person (

Line 4323: -- Returns whether a party exists in HZ_PARTIES based

4319: -----------------------------------------------------------
4320: -- PROCEDURE
4321: -- Party_Exists
4322: -- PURPOSE
4323: -- Returns whether a party exists in HZ_PARTIES based
4324: -- on the given DEDUPE_KEY.
4325: -- HISTORY
4326: -- 13-Nov-1999 choang Created.
4327: -----------------------------------------------------------