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 PON_NEG_TEAM_MEMBERS

Line 564: -- column of PON_NEG_TEAM_MEMBERS table.

560: -- Pre-reqs : Negotiation with the given trading_partner_contact_id
561: -- (p_From_FK_id) must exists in the database
562: --
563: -- Function : This procedure will be attached to the USER_ID
564: -- column of PON_NEG_TEAM_MEMBERS table.
565: --
566: -- It will NOT veto Party Merge in any case
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

Line 567: -- This will merge the all the PON_NEG_TEAM_MEMBERS records

563: -- Function : This procedure will be attached to the USER_ID
564: -- column of PON_NEG_TEAM_MEMBERS table.
565: --
566: -- It will NOT veto Party Merge in any case
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.

Line 576: -- The procedure will not update PON_NEG_TEAM_MEMBERS.USER_ID

572: --
573: -- It will not trown any error/exception in such scenario and will silently ignore
574: -- merge.
575: --
576: -- The procedure will not update PON_NEG_TEAM_MEMBERS.USER_ID
577: -- if there is a functional unique/primary key violation while updating the records.
578: --
579: -- Parameters:
580: -- IN : p_From_FK_id NUMBER Required, value of the from ID (e.g. Party,

Line 606: -- We will be updating the user_id column of pon_neg_team_members table

602: fnd_file.put_line (fnd_file.log, ' p_From_FK_id ' || p_From_FK_id);
603: fnd_file.put_line (fnd_file.log, ' p_To_FK_id ' || p_To_FK_id);
604:
605: --
606: -- We will be updating the user_id column of pon_neg_team_members table
607: -- if there are only one FND_USER associated with the merge from ot merge to party id.
608: -- We will not touch the pon_neg_team_members otherwise.
609: --
610: fnd_file.put_line (fnd_file.log, '10 : Buyer Merge - Calling HAS_MULTIPLE_FND_USERS function');

Line 608: -- We will not touch the pon_neg_team_members otherwise.

604:
605: --
606: -- We will be updating the user_id column of pon_neg_team_members table
607: -- if there are only one FND_USER associated with the merge from ot merge to party id.
608: -- We will not touch the pon_neg_team_members otherwise.
609: --
610: fnd_file.put_line (fnd_file.log, '10 : Buyer Merge - Calling HAS_MULTIPLE_FND_USERS function');
611:
612: IF (HAS_MULTIPLE_FND_USERS(p_To_FK_id) = FALSE AND

Line 615: fnd_file.put_line (fnd_file.log, '30 : Buyer Merge - Merging PON_NEG_TEAM_MEMBERS table');

611:
612: IF (HAS_MULTIPLE_FND_USERS(p_To_FK_id) = FALSE AND
613: HAS_MULTIPLE_FND_USERS(p_From_FK_id) = FALSE) THEN
614: fnd_file.put_line (fnd_file.log, '20 : Buyer Merge - Merge From and Merge To Party has one FND_USER');
615: fnd_file.put_line (fnd_file.log, '30 : Buyer Merge - Merging PON_NEG_TEAM_MEMBERS table');
616:
617: l_from_user_id := GET_USER_ID(p_From_FK_id);
618: l_to_user_id := GET_USER_ID(p_To_FK_id);
619:

Line 628: UPDATE PON_NEG_TEAM_MEMBERS pntm

624: -- That means we have exactly only one fnd user for each of the merging parties
625: --
626: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Both the parties have only one fnd user each');
627:
628: UPDATE PON_NEG_TEAM_MEMBERS pntm
629: SET pntm.USER_ID = l_to_user_id
630: WHERE pntm.USER_ID = l_from_user_id
631: AND NOT EXISTS (SELECT 'DUPLICATE'
632: FROM PON_NEG_TEAM_MEMBERS pntm1

Line 632: FROM PON_NEG_TEAM_MEMBERS pntm1

628: UPDATE PON_NEG_TEAM_MEMBERS pntm
629: SET pntm.USER_ID = l_to_user_id
630: WHERE pntm.USER_ID = l_from_user_id
631: AND NOT EXISTS (SELECT 'DUPLICATE'
632: FROM PON_NEG_TEAM_MEMBERS pntm1
633: WHERE pntm.auction_header_id = pntm1.auction_header_id
634: AND pntm1.USER_ID = l_to_user_id);
635:
636: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated USER IDs in PON_NEG_TEAM_MEMBERS: '||sql%rowcount||' rows');

Line 636: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated USER IDs in PON_NEG_TEAM_MEMBERS: '||sql%rowcount||' rows');

632: FROM PON_NEG_TEAM_MEMBERS pntm1
633: WHERE pntm.auction_header_id = pntm1.auction_header_id
634: AND pntm1.USER_ID = l_to_user_id);
635:
636: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated USER IDs in PON_NEG_TEAM_MEMBERS: '||sql%rowcount||' rows');
637:
638: END If;
639: END IF;
640:

Line 800: -- We will be updating the user_id column of pon_neg_team_members table

796:
797: fnd_file.put_line (fnd_file.log, '60 : Buyer Merge - Updated TPC IDs in PON_DISCUSSIONS');
798:
799: --
800: -- We will be updating the user_id column of pon_neg_team_members table
801: -- if there are only one FND_USER associated with the merge from ot merge to party id.
802: -- We will not touch the pon_neg_team_members otherwise.
803: --
804: fnd_file.put_line (fnd_file.log, '70 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 802: -- We will not touch the pon_neg_team_members otherwise.

798:
799: --
800: -- We will be updating the user_id column of pon_neg_team_members table
801: -- if there are only one FND_USER associated with the merge from ot merge to party id.
802: -- We will not touch the pon_neg_team_members otherwise.
803: --
804: fnd_file.put_line (fnd_file.log, '70 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
805:
806: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 959: -- We will be updating the user_id column of pon_neg_team_members table

955:
956: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Updated DRAFT_LOCKED_BY_CONTACT_IDs in PON_AUCTION_HEADERS_ALL: '||sql%rowcount||' rows');
957:
958: --
959: -- We will be updating the user_id column of pon_neg_team_members table
960: -- if there are only one FND_USER associated with the merge from ot merge to party id.
961: -- We will not touch the pon_neg_team_members otherwise.
962: --
963: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 961: -- We will not touch the pon_neg_team_members otherwise.

957:
958: --
959: -- We will be updating the user_id column of pon_neg_team_members table
960: -- if there are only one FND_USER associated with the merge from ot merge to party id.
961: -- We will not touch the pon_neg_team_members otherwise.
962: --
963: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
964:
965: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 1121: -- We will be updating the user_id column of pon_neg_team_members table

1117:
1118: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Updated DRAFT_UNLOCKED_BY_CONTACT_IDs in PON_AUCTION_HEADERS_ALL: '||sql%rowcount||' rows');
1119:
1120: --
1121: -- We will be updating the user_id column of pon_neg_team_members table
1122: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1123: -- We will not touch the pon_neg_team_members otherwise.
1124: --
1125: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 1123: -- We will not touch the pon_neg_team_members otherwise.

1119:
1120: --
1121: -- We will be updating the user_id column of pon_neg_team_members table
1122: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1123: -- We will not touch the pon_neg_team_members otherwise.
1124: --
1125: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
1126:
1127: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 1283: -- We will be updating the user_id column of pon_neg_team_members table

1279:
1280: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Updated SCORING_LOCK_TP_CONTACT_IDs in PON_AUCTION_HEADERS_ALL: '||sql%rowcount||' rows');
1281:
1282: --
1283: -- We will be updating the user_id column of pon_neg_team_members table
1284: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1285: -- We will not touch the pon_neg_team_members otherwise.
1286: --
1287: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 1285: -- We will not touch the pon_neg_team_members otherwise.

1281:
1282: --
1283: -- We will be updating the user_id column of pon_neg_team_members table
1284: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1285: -- We will not touch the pon_neg_team_members otherwise.
1286: --
1287: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
1288:
1289: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 1908: -- We will be updating the user_id column of pon_neg_team_members table

1904:
1905: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated SURROG_BID_CREATED_CONTACT_IDs in PON_BID_HEADERS: '||sql%rowcount||' rows');
1906:
1907: --
1908: -- We will be updating the user_id column of pon_neg_team_members table
1909: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1910: -- We will not touch the pon_neg_team_members otherwise.
1911: --
1912: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 1910: -- We will not touch the pon_neg_team_members otherwise.

1906:
1907: --
1908: -- We will be updating the user_id column of pon_neg_team_members table
1909: -- if there are only one FND_USER associated with the merge from ot merge to party id.
1910: -- We will not touch the pon_neg_team_members otherwise.
1911: --
1912: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
1913:
1914: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 2072: -- We will be updating the user_id column of pon_neg_team_members table

2068:
2069: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated SCORE_OVERRIDE_TP_CONTACT_IDs in PON_BID_HEADERS: '||sql%rowcount||' rows');
2070:
2071: --
2072: -- We will be updating the user_id column of pon_neg_team_members table
2073: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2074: -- We will not touch the pon_neg_team_members otherwise.
2075: --
2076: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 2074: -- We will not touch the pon_neg_team_members otherwise.

2070:
2071: --
2072: -- We will be updating the user_id column of pon_neg_team_members table
2073: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2074: -- We will not touch the pon_neg_team_members otherwise.
2075: --
2076: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
2077:
2078: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 2232: -- We will be updating the user_id column of pon_neg_team_members table

2228:
2229: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated SHORTLIST_TPC_IDs in PON_BID_HEADERS: '||sql%rowcount||' rows');
2230:
2231: --
2232: -- We will be updating the user_id column of pon_neg_team_members table
2233: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2234: -- We will not touch the pon_neg_team_members otherwise.
2235: --
2236: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 2234: -- We will not touch the pon_neg_team_members otherwise.

2230:
2231: --
2232: -- We will be updating the user_id column of pon_neg_team_members table
2233: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2234: -- We will not touch the pon_neg_team_members otherwise.
2235: --
2236: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
2237:
2238: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 2392: -- We will be updating the user_id column of pon_neg_team_members table

2388:
2389: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated AUTHORING_PARTY_CONTACT_IDs in PON_CONTRACTS: '||sql%rowcount||' rows');
2390:
2391: --
2392: -- We will be updating the user_id column of pon_neg_team_members table
2393: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2394: -- We will not touch the pon_neg_team_members otherwise.
2395: --
2396: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 2394: -- We will not touch the pon_neg_team_members otherwise.

2390:
2391: --
2392: -- We will be updating the user_id column of pon_neg_team_members table
2393: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2394: -- We will not touch the pon_neg_team_members otherwise.
2395: --
2396: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
2397:
2398: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 2712: -- We will be updating the user_id column of pon_neg_team_members table

2708:
2709: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated FROM_IDs in PON_THREAD_ENTRIES: '||sql%rowcount||' rows');
2710:
2711: --
2712: -- We will be updating the user_id column of pon_neg_team_members table
2713: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2714: -- We will not touch the pon_neg_team_members otherwise.
2715: --
2716: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 2714: -- We will not touch the pon_neg_team_members otherwise.

2710:
2711: --
2712: -- We will be updating the user_id column of pon_neg_team_members table
2713: -- if there are only one FND_USER associated with the merge from ot merge to party id.
2714: -- We will not touch the pon_neg_team_members otherwise.
2715: --
2716: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
2717:
2718: IF ( l_merge_scenario = G_BUYER) THEN

Line 3034: -- We will be updating the user_id column of pon_neg_team_members table

3030:
3031: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TO_IDs in PON_TE_RECIPIENTS: '||sql%rowcount||' rows');
3032:
3033: --
3034: -- We will be updating the user_id column of pon_neg_team_members table
3035: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3036: -- We will not touch the pon_neg_team_members otherwise.
3037: --
3038: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 3036: -- We will not touch the pon_neg_team_members otherwise.

3032:
3033: --
3034: -- We will be updating the user_id column of pon_neg_team_members table
3035: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3036: -- We will not touch the pon_neg_team_members otherwise.
3037: --
3038: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
3039:
3040: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 3195: -- We will be updating the user_id column of pon_neg_team_members table

3191:
3192: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated SURROG_BID_ACK_CONTACT_IDs in PON_ACKNOWLEDGEMENTS: '||sql%rowcount||' rows');
3193:
3194: --
3195: -- We will be updating the user_id column of pon_neg_team_members table
3196: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3197: -- We will not touch the pon_neg_team_members otherwise.
3198: --
3199: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 3197: -- We will not touch the pon_neg_team_members otherwise.

3193:
3194: --
3195: -- We will be updating the user_id column of pon_neg_team_members table
3196: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3197: -- We will not touch the pon_neg_team_members otherwise.
3198: --
3199: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
3200:
3201: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

Line 3354: -- We will be updating the user_id column of pon_neg_team_members table

3350:
3351: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated BUYER_TP_CONTACT_IDs in PON_SUPPLIER_ACCESS: '||sql%rowcount||' rows');
3352:
3353: --
3354: -- We will be updating the user_id column of pon_neg_team_members table
3355: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3356: -- We will not touch the pon_neg_team_members otherwise.
3357: --
3358: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

Line 3356: -- We will not touch the pon_neg_team_members otherwise.

3352:
3353: --
3354: -- We will be updating the user_id column of pon_neg_team_members table
3355: -- if there are only one FND_USER associated with the merge from ot merge to party id.
3356: -- We will not touch the pon_neg_team_members otherwise.
3357: --
3358: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');
3359:
3360: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,