APPS.IBE_MERGE_PVT dependencies on HZ_PARTIES

Line 27: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

23: *----------------------------------------------------------------------------*/
24: Function Allow_merge(p_customer_id NUMBER,
25: p_duplicate_id NUMBER) Return Varchar2
26: IS
27: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
28: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
29: l_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
30: l_allow_merge_flag VARCHAR2(1) := 'Y';
31:

Line 28: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

24: Function Allow_merge(p_customer_id NUMBER,
25: p_duplicate_id NUMBER) Return Varchar2
26: IS
27: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
28: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
29: l_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
30: l_allow_merge_flag VARCHAR2(1) := 'Y';
31:
32: Begin

Line 29: l_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;

25: p_duplicate_id NUMBER) Return Varchar2
26: IS
27: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
28: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
29: l_dup_party_id HZ_PARTIES.PARTY_ID%TYPE;
30: l_allow_merge_flag VARCHAR2(1) := 'Y';
31:
32: Begin
33: IBE_Util.Debug('IBE_MERGE_PVT.Allow_merge - Entering Allow merge with customer_id: '||p_customer_id||' and duplicate id: '||p_duplicate_id);

Line 38: From hz_parties

34:
35: l_allow_merge_flag := 'Y';
36:
37: Select party_type,party_id into l_party_type,l_party_id
38: From hz_parties
39: Where party_id in (Select party_id from hz_cust_accounts
40: Where cust_account_id = p_customer_id);
41:
42: Select party_id into l_dup_party_id

Line 43: From hz_parties

39: Where party_id in (Select party_id from hz_cust_accounts
40: Where cust_account_id = p_customer_id);
41:
42: Select party_id into l_dup_party_id
43: From hz_parties
44: Where party_id in (Select party_id from hz_cust_accounts
45: Where cust_account_id = p_duplicate_id);
46:
47: IBE_Util.Debug('IBE_MERGE_PVT.Allow_merge -party_type: '||l_party_type||' party_id: '||l_party_id||' and duplicate party id: '||l_dup_party_id);

Line 1094: if p_parent_entity_name = 'HZ_PARTIES' Then

1090:
1091:
1092: if p_from_fk_id <> p_to_fk_id Then
1093:
1094: if p_parent_entity_name = 'HZ_PARTIES' Then
1095:
1096: --fix 2899235: delete only, don't change
1097: delete IBE_ORD_ONECLICK_ALL
1098: where party_id = p_from_fk_id;

Line 1301: if p_parent_entity_name = 'HZ_PARTIES' Then

1297:
1298:
1299: if p_from_fk_id <> p_to_fk_id Then
1300:
1301: if p_parent_entity_name = 'HZ_PARTIES' Then
1302:
1303: --iterate each record in the site access table
1304: open merge_records(p_from_fk_id);
1305: loop

Line 1459: if p_parent_entity_name = 'HZ_PARTIES' Then

1455: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1456: arp_message.set_token('TABLE_NAME', 'IBE_SH_QUOTE_ACCESS', FALSE);
1457: open find_account(p_to_fk_id);
1458: fetch find_account into l_to_cust_account_id ;
1459: if p_parent_entity_name = 'HZ_PARTIES' Then
1460: Open MERGE_FROM_SH;
1461: Loop
1462: Fetch MERGE_FROM_SH into l_quote_header_id, l_from_cust_account_id;
1463: EXIT When merge_from_sh%NOTFOUND;