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 FND_USER

Line 406: -- return FND_USER.USER_NAME as it was BEFORE the merge

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
407: -- operation started.
408: -- It will reutn the FIRST user_name in case the given user party_id
409: -- is mapped to more than one user in FND_USER table.
410: -- It returns NULL if there are no user attached

Line 409: -- is mapped to more than one user in FND_USER table.

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
407: -- operation started.
408: -- It will reutn the FIRST user_name in case the given user party_id
409: -- is mapped to more than one user in FND_USER table.
410: -- It returns NULL if there are no user attached
411: --
412: -- Parameters:
413: -- IN : p_user_party_id NUMBER Required, the User Party Id

Line 427: l_user_name FND_USER.USER_NAME%TYPE;

423: )
424: RETURN VARCHAR2
425: IS
426: PRAGMA AUTONOMOUS_TRANSACTION;
427: l_user_name FND_USER.USER_NAME%TYPE;
428: BEGIN
429:
430: BEGIN
431: SELECT

Line 435: FROM FND_USER fu,

431: SELECT
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;

Line 458: -- return FND_USER.USER_ID as it was BEFORE the merge

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
459: -- operation started.
460: -- It will reutn the FIRST user_id in case the given user party_id
461: -- is mapped to more than one user in FND_USER table.
462: -- It returns NULL if there are no user attached

Line 461: -- is mapped to more than one user in FND_USER table.

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
459: -- operation started.
460: -- It will reutn the FIRST user_id in case the given user party_id
461: -- is mapped to more than one user in FND_USER table.
462: -- It returns NULL if there are no user attached
463: --
464: -- Parameters:
465: -- IN : p_user_party_id NUMBER Required, the User Party Id

Line 479: l_user_id FND_USER.USER_ID%TYPE;

475: )
476: RETURN NUMBER
477: IS
478: PRAGMA AUTONOMOUS_TRANSACTION;
479: l_user_id FND_USER.USER_ID%TYPE;
480: BEGIN
481:
482: BEGIN
483: SELECT

Line 487: FROM FND_USER fu,

483: SELECT
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;

Line 501: -- API name : HAS_MULTIPLE_FND_USERS

497: RETURN l_user_id;
498: END GET_USER_ID;
499:
500: -- Start of comments
501: -- API name : HAS_MULTIPLE_FND_USERS
502: --
503: -- Type : Private
504: --
505: -- Pre-reqs : Given Company Party Id(p_user_party_id)

Line 510: -- return true if there are multiple FND_USERs associated with

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
511: -- given user party id (p_user_party_id)
512: -- It will reutn false otherwise even if there are no FND_USER
513: -- associated
514: --

Line 512: -- It will reutn false otherwise even if there are no FND_USER

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
511: -- given user party id (p_user_party_id)
512: -- It will reutn false otherwise even if there are no FND_USER
513: -- associated
514: --
515: -- Parameters:
516: -- IN : p_user_party_id NUMBER Required, the User Party Id

Line 524: FUNCTION HAS_MULTIPLE_FND_USERS (

520: -- Previous version 1.0
521: -- Initial version 1.0
522: --
523: -- End of comments
524: FUNCTION HAS_MULTIPLE_FND_USERS (
525: p_user_party_id IN NUMBER
526: )
527: RETURN BOOLEAN
528: IS

Line 538: FROM FND_USER fu,

534: SELECT
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

Line 552: END HAS_MULTIPLE_FND_USERS;

548: RETURN TRUE;
549: ELSE
550: RETURN FALSE;
551: END IF;
552: END HAS_MULTIPLE_FND_USERS;
553:
554:
555: -- Start of comments
556: -- API name : MERGE_NEG_TEAM_FND_USER

Line 556: -- API name : MERGE_NEG_TEAM_FND_USER

552: END HAS_MULTIPLE_FND_USERS;
553:
554:
555: -- Start of comments
556: -- API name : MERGE_NEG_TEAM_FND_USER
557: --
558: -- Type : Group
559: --
560: -- Pre-reqs : Negotiation with the given trading_partner_contact_id

Line 568: -- having USER_ID equals to the only FND_USER mapped to p_From_FK_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.
572: --

Line 569: -- to only FND_USER mapped to party id having value (p_To_FK_id).

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.
572: --
573: -- It will not trown any error/exception in such scenario and will silently ignore

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 591: PROCEDURE MERGE_NEG_TEAM_FND_USER (

587: -- Previous version 1.0
588: -- Initial version 1.0
589: --
590: -- End of comments
591: PROCEDURE MERGE_NEG_TEAM_FND_USER (
592: p_From_FK_id IN NUMBER,
593: p_To_FK_id IN NUMBER)
594: IS
595: l_to_user_id FND_USER.USER_ID%TYPE;

Line 595: l_to_user_id FND_USER.USER_ID%TYPE;

591: PROCEDURE MERGE_NEG_TEAM_FND_USER (
592: p_From_FK_id IN NUMBER,
593: p_To_FK_id IN NUMBER)
594: IS
595: l_to_user_id FND_USER.USER_ID%TYPE;
596: l_from_user_id FND_USER.USER_ID%TYPE;
597:
598: BEGIN
599: --{start of procedure

Line 596: l_from_user_id FND_USER.USER_ID%TYPE;

592: p_From_FK_id IN NUMBER,
593: p_To_FK_id IN NUMBER)
594: IS
595: l_to_user_id FND_USER.USER_ID%TYPE;
596: l_from_user_id FND_USER.USER_ID%TYPE;
597:
598: BEGIN
599: --{start of procedure
600:

Line 601: fnd_file.put_line (fnd_file.log, 'Start : PON_TCA_MERGE_PVT.MERGE_NEG_TEAM_FND_USER ');

597:
598: BEGIN
599: --{start of procedure
600:
601: fnd_file.put_line (fnd_file.log, 'Start : PON_TCA_MERGE_PVT.MERGE_NEG_TEAM_FND_USER ');
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: --

Line 607: -- if there are only one FND_USER associated with the merge from ot merge to party 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');
611:

Line 610: fnd_file.put_line (fnd_file.log, '10 : Buyer Merge - Calling HAS_MULTIPLE_FND_USERS function');

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
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');

Line 612: IF (HAS_MULTIPLE_FND_USERS(p_To_FK_id) = FALSE AND

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

Line 613: HAS_MULTIPLE_FND_USERS(p_From_FK_id) = FALSE) THEN

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
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);

Line 614: fnd_file.put_line (fnd_file.log, '20 : Buyer Merge - Merge From and Merge To Party has one FND_USER');

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
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);

Line 624: -- That means we have exactly only one fnd user for each of the merging parties

620: IF (l_from_user_id IS NOT NULL AND
621: l_to_user_id IS NOT NULL ) THEN
622:
623: --
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

Line 626: fnd_file.put_line (fnd_file.log, '40 : Buyer Merge - Both the parties have only one fnd user each');

622:
623: --
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

Line 647: fnd_file.put_line (fnd_file.log, '60 : Error in PON_TCA_PARTY_MERGE.MERGE_NEG_TEAM_FND_USER SQLERRM:'||SQLERRM);

643:
644: --
645: -- We need add some Sourcing specific message for this
646: --
647: fnd_file.put_line (fnd_file.log, '60 : Error in PON_TCA_PARTY_MERGE.MERGE_NEG_TEAM_FND_USER SQLERRM:'||SQLERRM);
648: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
650: FND_MSG_PUB.ADD;
651:

Line 653: END MERGE_NEG_TEAM_FND_USER;

649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
650: FND_MSG_PUB.ADD;
651:
652: --} end of procedure
653: END MERGE_NEG_TEAM_FND_USER;
654:
655:
656: -- Start of comments
657: -- API name : NEG_TPC_MERGE

Line 725: l_user_name FND_USER.USER_NAME%TYPE;

721: p_Batch_Party_id IN NUMBER,
722: x_return_status IN OUT NOCOPY VARCHAR2 )
723: IS
724: l_merge_scenario VARCHAR2(20);
725: l_user_name FND_USER.USER_NAME%TYPE;
726: l_to_user_id FND_USER.USER_ID%TYPE;
727: l_from_user_id FND_USER.USER_ID%TYPE;
728:
729: BEGIN

Line 726: l_to_user_id FND_USER.USER_ID%TYPE;

722: x_return_status IN OUT NOCOPY VARCHAR2 )
723: IS
724: l_merge_scenario VARCHAR2(20);
725: l_user_name FND_USER.USER_NAME%TYPE;
726: l_to_user_id FND_USER.USER_ID%TYPE;
727: l_from_user_id FND_USER.USER_ID%TYPE;
728:
729: BEGIN
730: --{start of procedure

Line 727: l_from_user_id FND_USER.USER_ID%TYPE;

723: IS
724: l_merge_scenario VARCHAR2(20);
725: l_user_name FND_USER.USER_NAME%TYPE;
726: l_to_user_id FND_USER.USER_ID%TYPE;
727: l_from_user_id FND_USER.USER_ID%TYPE;
728:
729: BEGIN
730: --{start of procedure
731:

Line 801: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
805:

Line 804: fnd_file.put_line (fnd_file.log, '70 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
807: p_To_FK_id => p_To_FK_id);
808:

Line 806: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
807: p_To_FK_id => p_To_FK_id);
808:
809: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
810: --

Line 960: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
964:

Line 963: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
966: p_To_FK_id => p_To_FK_id);
967:

Line 965: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
966: p_To_FK_id => p_To_FK_id);
967:
968: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
969: --

Line 1122: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
1126:

Line 1125: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
1128: p_To_FK_id => p_To_FK_id);
1129:

Line 1127: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
1128: p_To_FK_id => p_To_FK_id);
1129:
1130: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
1131:

Line 1284: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
1288:

Line 1287: fnd_file.put_line (fnd_file.log, '45 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
1290: p_To_FK_id => p_To_FK_id);
1291:

Line 1289: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
1290: p_To_FK_id => p_To_FK_id);
1291:
1292:
1293: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN

Line 1909: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
1913:

Line 1912: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
1915: p_To_FK_id => p_To_FK_id);
1916:

Line 1914: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
1915: p_To_FK_id => p_To_FK_id);
1916:
1917:
1918: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN

Line 2073: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
2077:

Line 2076: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
2079: p_To_FK_id => p_To_FK_id);
2080:

Line 2078: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
2079: p_To_FK_id => p_To_FK_id);
2080:
2081: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
2082: --

Line 2233: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
2237:

Line 2236: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
2239: p_To_FK_id => p_To_FK_id);
2240:

Line 2238: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
2239: p_To_FK_id => p_To_FK_id);
2240:
2241: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
2242: --

Line 2393: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
2397:

Line 2396: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
2399: p_To_FK_id => p_To_FK_id);
2400:

Line 2398: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
2399: p_To_FK_id => p_To_FK_id);
2400:
2401: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
2402: --

Line 2713: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
2717:

Line 2716: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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
2719: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,
2720: p_To_FK_id => p_To_FK_id);

Line 2719: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,

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
2719: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_id,
2720: p_To_FK_id => p_To_FK_id);
2721: END IF;
2722:
2723:

Line 3035: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
3039:

Line 3038: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
3041: p_To_FK_id => p_To_FK_id);
3042:

Line 3040: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
3041: p_To_FK_id => p_To_FK_id);
3042:
3043: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
3044: --

Line 3196: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
3200:

Line 3199: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
3202: p_To_FK_id => p_To_FK_id);
3203:

Line 3201: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
3202: p_To_FK_id => p_To_FK_id);
3203:
3204: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
3205: --

Line 3355: -- if there are only one FND_USER associated with the merge from ot merge to party id.

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');
3359:

Line 3358: fnd_file.put_line (fnd_file.log, '55 : Buyer Merge - Calling MERGE_NEG_TEAM_FND_USER procedure');

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,
3361: p_To_FK_id => p_To_FK_id);
3362:

Line 3360: MERGE_NEG_TEAM_FND_USER (p_From_FK_id => p_From_FK_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,
3361: p_To_FK_id => p_To_FK_id);
3362:
3363: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
3364: --

Line 4074: l_user_name FND_USER.USER_NAME%TYPE;

4070: p_Batch_Party_id IN NUMBER,
4071: x_return_status IN OUT NOCOPY VARCHAR2 )
4072: IS
4073: l_merge_scenario VARCHAR2(20);
4074: l_user_name FND_USER.USER_NAME%TYPE;
4075:
4076: BEGIN
4077: --{start of procedure
4078: