APPS.AMS_PARTYIMPORT_PVT dependencies on AMS_PARTY_DEDUPE

Line 3666: -- Initialize the table AMS_PARTY_DEDUPE.

3662: -----------------------------------------------------------
3663: -- PROCEDURE
3664: -- Initialize_Dedupe_Table
3665: -- PURPOSE
3666: -- Initialize the table AMS_PARTY_DEDUPE.
3667: -- HISTORY
3668: -- 11-Nov-1999 choang Created.
3669: -----------------------------------------------------------
3670: PROCEDURE Initialize_Dedupe_Table

Line 3673: DELETE FROM ams_party_dedupe;

3669: -----------------------------------------------------------
3670: PROCEDURE Initialize_Dedupe_Table
3671: IS
3672: BEGIN
3673: DELETE FROM ams_party_dedupe;
3674: END Initialize_Dedupe_Table;
3675:
3676:
3677: -----------------------------------------------------------

Line 3681: -- Synchronize the PARTY_ID of AMS_PARTY_DEDUPE with

3677: -----------------------------------------------------------
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: -----------------------------------------------------------

Line 3689: INSERT INTO ams_party_dedupe (

3685: -----------------------------------------------------------
3686: PROCEDURE Synchronize_ID
3687: IS
3688: BEGIN
3689: INSERT INTO ams_party_dedupe (
3690: party_id,
3691: last_update_date,
3692: last_updated_by,
3693: creation_date,

Line 3714: -- Populate the DEDUPE_KEY in AMS_PARTY_DEDUPE with

3710: -----------------------------------------------------------
3711: -- PROCEDURE
3712: -- Populate_Keys
3713: -- PURPOSE
3714: -- Populate the DEDUPE_KEY in AMS_PARTY_DEDUPE with
3715: -- the derived key using the Generate_Key API.
3716: -- HISTORY
3717: -- 11-Nov-1999 choang Created.
3718: -- 07-Jan-2000 choang Removed dbms_output due to problem with

Line 3748: FROM ams_party_dedupe

3744: -- NOTE: Not using "WHERE CURRENT OF"
3745: -- in the update statment due to bug 219936.
3746: CURSOR c_id IS
3747: SELECT party_id
3748: FROM ams_party_dedupe
3749: WHERE dedupe_key IS NULL
3750: FOR UPDATE NOWAIT
3751: ;
3752: BEGIN

Line 3779: UPDATE ams_party_dedupe

3775: p_word_replacement_flag => p_word_replacement_flag,
3776: x_dedupe_key => l_dedupe_key
3777: );
3778:
3779: UPDATE ams_party_dedupe
3780: SET
3781: dedupe_key = l_dedupe_key,
3782: last_update_date = SYSDATE,
3783: last_updated_by = FND_GLOBAL.user_id,

Line 4338: FROM ams_party_dedupe

4334:
4335:
4336: CURSOR c_exists IS
4337: SELECT party_id
4338: FROM ams_party_dedupe
4339: WHERE dedupe_key = p_dedupe_key
4340: ;
4341: BEGIN
4342: OPEN c_exists;