eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_TCA_MERGE_PVT dependencies on HZ_PARTIES

Line 52: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

48: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
49: -- Party Site, etc.) when merge is executed
50: --
51: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
52: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
53: --
54: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
55: -- Party Merge is executed
56: --

Line 106: -- must exists in the HZ_PARTIES table

102: --
103: -- Type : Private
104: --
105: -- Pre-reqs : Given Party Id(p_from_id, to_from_id)
106: -- must exists in the HZ_PARTIES table
107: --
108: -- Function : This function will expect and accept to person party id
109: -- (merge from party id and merge to party id) and it will
110: -- return following values depending on the the situation

Line 174: HZ_PARTIES USER_PARTIES,

170: CURSOR CHECK_USER_TYPE (p_user_party_id NUMBER)
171: IS
172: SELECT 'BUYER' AS USER_TYPE
173: FROM
174: HZ_PARTIES USER_PARTIES,
175: HZ_RELATIONSHIPS,
176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID

Line 184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION
188: SELECT 'SELLER' AS USER_TYPE

Line 257: -- must exists in the HZ_PARTIES table

253: --
254: -- Type : Private
255: --
256: -- Pre-reqs : Given Company Party Id(p_from_id, to_from_id)
257: -- must exists in the HZ_PARTIES table
258: --
259: -- Function : This function will expect and accept to company party id
260: -- (merge from party id and merge to party id) and it will
261: -- return following values depending on the the situation

Line 325: HZ_PARTIES USER_PARTIES,

321: CURSOR CHECK_COMPANY_TYPE (p_party_id NUMBER)
322: IS
323: SELECT 'BUYER' AS COMPANY_TYPE
324: FROM
325: HZ_PARTIES USER_PARTIES,
326: HZ_CODE_ASSIGNMENTS
327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID

Line 330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

326: HZ_CODE_ASSIGNMENTS
327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
333: UNION
334: SELECT 'SELLER' AS COMPANY_TYPE

Line 402: -- must exists in the HZ_PARTIES table

398: --
399: -- Type : Private
400: --
401: -- Pre-reqs : Given Company Party Id(p_user_party_id)
402: -- must exists in the HZ_PARTIES table
403: --
404: -- Function : This function will expect and accept to company party id
405: -- (given user party id as present in HZ before merge) and it will
406: -- return FND_USER.USER_NAME as it was BEFORE the merge

Line 436: HZ_PARTIES hz

432: fu.USER_NAME
433: INTO
434: l_user_name
435: FROM FND_USER fu,
436: HZ_PARTIES hz
437: WHERE fu.PERSON_PARTY_ID=hz.PARTY_ID
438: AND hz.PARTY_ID= p_user_party_id
439: AND ROWNUM = 1;
440: EXCEPTION

Line 454: -- must exists in the HZ_PARTIES table

450: --
451: -- Type : Private
452: --
453: -- Pre-reqs : Given Company Party Id(p_user_party_id)
454: -- must exists in the HZ_PARTIES table
455: --
456: -- Function : This function will expect and accept to company party id
457: -- (given user party id as present in HZ before merge) and it will
458: -- return FND_USER.USER_ID as it was BEFORE the merge

Line 488: HZ_PARTIES hz

484: fu.USER_ID
485: INTO
486: l_user_id
487: FROM FND_USER fu,
488: HZ_PARTIES hz
489: WHERE fu.PERSON_PARTY_ID=hz.PARTY_ID
490: AND hz.PARTY_ID= p_user_party_id
491: AND ROWNUM = 1;
492: EXCEPTION

Line 506: -- must exists in the HZ_PARTIES table

502: --
503: -- Type : Private
504: --
505: -- Pre-reqs : Given Company Party Id(p_user_party_id)
506: -- must exists in the HZ_PARTIES table
507: --
508: -- Function : This function will accept a user party id
509: -- (given user party id as present in HZ before merge) and it will
510: -- return true if there are multiple FND_USERs associated with

Line 539: HZ_PARTIES hz

535: COUNT(fu.USER_NAME)
536: INTO
537: l_user_name_count
538: FROM FND_USER fu,
539: HZ_PARTIES hz
540: WHERE fu.PERSON_PARTY_ID=hz.PARTY_ID
541: AND hz.PARTY_ID= p_user_party_id;
542: EXCEPTION
543: WHEN OTHERS THEN

Line 571: -- have more than one FND_USER record mapped to one person in HZ_PARTIES.

567: -- This will merge the all the PON_NEG_TEAM_MEMBERS records
568: -- having USER_ID equals to the only FND_USER mapped to p_From_FK_id
569: -- to only FND_USER mapped to party id having value (p_To_FK_id).
570: -- It will NOT merge the USER_ID information if any of the merging parties
571: -- have more than one FND_USER record mapped to one person in HZ_PARTIES.
572: --
573: -- It will not trown any error/exception in such scenario and will silently ignore
574: -- merge.
575: --

Line 691: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

687: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
688: -- Party Site, etc.) when merge is executed
689: --
690: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
691: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
692: --
693: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
694: -- Party Merge is executed
695: --

Line 868: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

864: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
865: -- Party Site, etc.) when merge is executed
866: --
867: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
868: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
869: --
870: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
871: -- Party Merge is executed
872: --

Line 1027: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1023: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1024: -- Party Site, etc.) when merge is executed
1025: --
1026: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1027: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1028: --
1029: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1030: -- Party Merge is executed
1031: --

Line 1191: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1187: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1188: -- Party Site, etc.) when merge is executed
1189: --
1190: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1191: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1192: --
1193: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1194: -- Party Merge is executed
1195: --

Line 1353: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1349: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1350: -- Party Site, etc.) when merge is executed
1351: --
1352: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1353: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1354: --
1355: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1356: -- Party Merge is executed
1357: --

Line 1428: fnd_file.put_line (fnd_file.log, '30 : Buyer Merge - Getting Person Name from HZ_PARTIES');

1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425:
1426: ELSIF (l_merge_scenario = G_BUYER) THEN
1427:
1428: fnd_file.put_line (fnd_file.log, '30 : Buyer Merge - Getting Person Name from HZ_PARTIES');
1429: --
1430: -- Now transact the data we have
1431: --
1432: SELECT

Line 1436: FROM HZ_PARTIES hz

1432: SELECT
1433: hz.person_first_name ||' '|| hz.person_last_name as person_name
1434: INTO
1435: l_person_name
1436: FROM HZ_PARTIES hz
1437: WHERE hz.PARTY_ID= p_To_FK_id;
1438:
1439: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Person Name from HZ:'|| l_person_name);
1440: --

Line 1512: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1508: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1509: -- Party Site, etc.) when merge is executed
1510: --
1511: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1512: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1513: --
1514: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1515: -- Party Merge is executed
1516: --

Line 1665: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1661: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1662: -- Party Site, etc.) when merge is executed
1663: --
1664: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1665: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1666: --
1667: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1668: -- Party Merge is executed
1669: --

Line 1817: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1813: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1814: -- Party Site, etc.) when merge is executed
1815: --
1816: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1817: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1818: --
1819: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1820: -- Party Merge is executed
1821: --

Line 1978: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

1974: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
1975: -- Party Site, etc.) when merge is executed
1976: --
1977: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
1978: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
1979: --
1980: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
1981: -- Party Merge is executed
1982: --

Line 2141: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2137: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2138: -- Party Site, etc.) when merge is executed
2139: --
2140: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2141: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2142: --
2143: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2144: -- Party Merge is executed
2145: --

Line 2300: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2296: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2297: -- Party Site, etc.) when merge is executed
2298: --
2299: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2300: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2301: --
2302: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2303: -- Party Merge is executed
2304: --

Line 2463: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2459: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2460: -- Party Site, etc.) when merge is executed
2461: --
2462: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2463: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2464: --
2465: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2466: -- Party Merge is executed
2467: --

Line 2608: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2604: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2605: -- Party Site, etc.) when merge is executed
2606: --
2607: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2608: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2609: --
2610: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2611: -- Party Merge is executed
2612: --

Line 2642: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2638: p_Batch_Party_id IN NUMBER,
2639: x_return_status IN OUT NOCOPY VARCHAR2 )
2640: IS
2641: l_merge_scenario VARCHAR2(20);
2642: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2643: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2644:
2645: BEGIN
2646: --{start of procedure

Line 2643: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2639: x_return_status IN OUT NOCOPY VARCHAR2 )
2640: IS
2641: l_merge_scenario VARCHAR2(20);
2642: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2643: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2644:
2645: BEGIN
2646: --{start of procedure
2647:

Line 2690: FROM HZ_PARTIES hz

2686: hz.PERSON_LAST_NAME
2687: INTO
2688: l_first_name,
2689: l_last_name
2690: FROM HZ_PARTIES hz
2691: WHERE hz.PARTY_ID= p_To_FK_id;
2692:
2693: fnd_file.put_line (fnd_file.log, '40 : Buyer or Seller Merge - Person Name from HZ:'|| l_first_name||','||l_last_name);
2694:

Line 2789: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2785: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2786: -- Party Site, etc.) when merge is executed
2787: --
2788: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2789: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2790: --
2791: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2792: -- Party Merge is executed
2793: --

Line 2823: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2819: p_Batch_Party_id IN NUMBER,
2820: x_return_status IN OUT NOCOPY VARCHAR2 )
2821: IS
2822: l_merge_scenario VARCHAR2(20);
2823: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2824: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2825:
2826: BEGIN
2827: --{start of procedure

Line 2824: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2820: x_return_status IN OUT NOCOPY VARCHAR2 )
2821: IS
2822: l_merge_scenario VARCHAR2(20);
2823: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2824: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2825:
2826: BEGIN
2827: --{start of procedure
2828:

Line 2926: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

2922: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
2923: -- Party Site, etc.) when merge is executed
2924: --
2925: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
2926: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
2927: --
2928: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
2929: -- Party Merge is executed
2930: --

Line 2960: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2956: p_Batch_Party_id IN NUMBER,
2957: x_return_status IN OUT NOCOPY VARCHAR2 )
2958: IS
2959: l_merge_scenario VARCHAR2(20);
2960: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2961: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2962:
2963: BEGIN
2964: --{start of procedure

Line 2961: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2957: x_return_status IN OUT NOCOPY VARCHAR2 )
2958: IS
2959: l_merge_scenario VARCHAR2(20);
2960: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2961: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2962:
2963: BEGIN
2964: --{start of procedure
2965:

Line 3007: FROM HZ_PARTIES hz

3003: hz.PERSON_LAST_NAME
3004: INTO
3005: l_first_name,
3006: l_last_name
3007: FROM HZ_PARTIES hz
3008: WHERE hz.PARTY_ID= p_To_FK_id;
3009:
3010: fnd_file.put_line (fnd_file.log, '40 : Buyer or Seller Merge - Person Name from HZ:'|| l_first_name||','||l_last_name);
3011:

Line 3102: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3098: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3099: -- Party Site, etc.) when merge is executed
3100: --
3101: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3102: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3103: --
3104: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3105: -- Party Merge is executed
3106: --

Line 3263: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3259: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3260: -- Party Site, etc.) when merge is executed
3261: --
3262: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3263: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3264: --
3265: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3266: -- Party Merge is executed
3267: --

Line 3422: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3418: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3419: -- Party Site, etc.) when merge is executed
3420: --
3421: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3422: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3423: --
3424: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3425: -- Party Merge is executed
3426: --

Line 3504: FROM HZ_PARTIES hz

3500: SELECT
3501: hz.person_last_name ||', '|| hz.person_first_name as person_name
3502: INTO
3503: l_person_name
3504: FROM HZ_PARTIES hz
3505: WHERE hz.PARTY_ID= p_To_FK_id;
3506:
3507: fnd_file.put_line (fnd_file.log, '40 : Seller Merge - Person Name from HZ:'|| l_person_name);
3508: --

Line 3584: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3580: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3581: -- Party Site, etc.) when merge is executed
3582: --
3583: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3584: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3585: --
3586: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3587: -- Party Merge is executed
3588: --

Line 3665: FROM HZ_PARTIES hz

3661: SELECT
3662: hz.person_last_name ||', '|| hz.person_first_name as person_name
3663: INTO
3664: l_person_name
3665: FROM HZ_PARTIES hz
3666: WHERE hz.PARTY_ID= p_To_FK_id;
3667:
3668: fnd_file.put_line (fnd_file.log, '40 : Seller Merge - Person Name from HZ:'|| l_person_name);
3669: --

Line 3745: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3741: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3742: -- Party Site, etc.) when merge is executed
3743: --
3744: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3745: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3746: --
3747: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3748: -- Party Merge is executed
3749: --

Line 3893: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

3889: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
3890: -- Party Site, etc.) when merge is executed
3891: --
3892: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
3893: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
3894: --
3895: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
3896: -- Party Merge is executed
3897: --

Line 4040: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

4036: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
4037: -- Party Site, etc.) when merge is executed
4038: --
4039: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
4040: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
4041: --
4042: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
4043: -- Party Merge is executed
4044: --

Line 4207: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

4203: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
4204: -- Party Site, etc.) when merge is executed
4205: --
4206: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
4207: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
4208: --
4209: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
4210: -- Party Merge is executed
4211: --

Line 4354: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

4350: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
4351: -- Party Site, etc.) when merge is executed
4352: --
4353: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
4354: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
4355: --
4356: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
4357: -- Party Merge is executed
4358: --

Line 4506: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

4502: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
4503: -- Party Site, etc.) when merge is executed
4504: --
4505: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
4506: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
4507: --
4508: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
4509: -- Party Merge is executed
4510: --

Line 4654: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)

4650: -- IN : p_To_FK_id NUMBER Required, Value of the to ID (e.g. Party,
4651: -- Party Site, etc.) when merge is executed
4652: --
4653: -- IN : p_Entity_name VARCHAR2 Required, Name of parent HZ
4654: -- table (e.g. HZ_PARTIES, HZ_PARTY_SITES)
4655: --
4656: -- IN : p_batch_id NUMBER Required, ID of the batch in which the
4657: -- Party Merge is executed
4658: --