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.HZ_POPULATE_BOT_PKG dependencies on HZ_PERSON_INTEREST

Line 653: -- Procedure name: pop_hz_person_interest()

649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END pop_hz_person_language;
651:
652: -----------------------------------------------------------------
653: -- Procedure name: pop_hz_person_interest()
654: -- Purpose: populates BOT for HZ_PERSON_INTEREST create or update
655: -- Scope: internal
656: -- Called From: V2 API
657: -- Called By: HZ_PERSON_INTEREST create or update APIs

Line 654: -- Purpose: populates BOT for HZ_PERSON_INTEREST create or update

650: END pop_hz_person_language;
651:
652: -----------------------------------------------------------------
653: -- Procedure name: pop_hz_person_interest()
654: -- Purpose: populates BOT for HZ_PERSON_INTEREST create or update
655: -- Scope: internal
656: -- Called From: V2 API
657: -- Called By: HZ_PERSON_INTEREST create or update APIs
658: -- Input Parameters:

Line 657: -- Called By: HZ_PERSON_INTEREST create or update APIs

653: -- Procedure name: pop_hz_person_interest()
654: -- Purpose: populates BOT for HZ_PERSON_INTEREST create or update
655: -- Scope: internal
656: -- Called From: V2 API
657: -- Called By: HZ_PERSON_INTEREST create or update APIs
658: -- Input Parameters:
659: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
660: -- p_person_interest_id IN NUMBER
661: --

Line 663: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_INTEREST

659: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
660: -- p_person_interest_id IN NUMBER
661: --
662: -- Note:
663: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_INTEREST
664: -- This procedure must ensure that the combination is valid before populating BOT
665: --
666: -- PARENT BO: PERSON :: CHILD BO:
667: -----------------------------------------------------------------

Line 668: PROCEDURE pop_hz_person_interest(p_operation IN VARCHAR2, p_person_interest_id IN NUMBER) IS

664: -- This procedure must ensure that the combination is valid before populating BOT
665: --
666: -- PARENT BO: PERSON :: CHILD BO:
667: -----------------------------------------------------------------
668: PROCEDURE pop_hz_person_interest(p_operation IN VARCHAR2, p_person_interest_id IN NUMBER) IS
669:
670: -- cursor statement to select the info from child table
671: CURSOR C_child IS
672: SELECT pi.LAST_UPDATE_DATE lud, pi.PARTY_ID parent_id, pi.PERSON_INTEREST_ID child_id

Line 673: FROM HZ_PERSON_INTEREST pi, HZ_PARTIES p

669:
670: -- cursor statement to select the info from child table
671: CURSOR C_child IS
672: SELECT pi.LAST_UPDATE_DATE lud, pi.PARTY_ID parent_id, pi.PERSON_INTEREST_ID child_id
673: FROM HZ_PERSON_INTEREST pi, HZ_PARTIES p
674: WHERE pi.PERSON_INTEREST_ID = P_PERSON_INTEREST_ID
675: AND pi.party_id = p.party_id
676: AND p.party_type = 'PERSON';
677:

Line 679: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_interest';

675: AND pi.party_id = p.party_id
676: AND p.party_type = 'PERSON';
677:
678: -- local variables
679: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_interest';
680: l_parent_id NUMBER; -- used to store parent entity identifier
681: l_child_id NUMBER; -- used to store HZ_PERSON_INTEREST identifier
682: l_lud DATE; -- used to store the child last update date
683: l_child_rec_exists_no NUMBER;

Line 681: l_child_id NUMBER; -- used to store HZ_PERSON_INTEREST identifier

677:
678: -- local variables
679: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_interest';
680: l_parent_id NUMBER; -- used to store parent entity identifier
681: l_child_id NUMBER; -- used to store HZ_PERSON_INTEREST identifier
682: l_lud DATE; -- used to store the child last update date
683: l_child_rec_exists_no NUMBER;
684: l_cen VARCHAR2(30) := 'HZ_PERSON_INTEREST';
685: BEGIN

Line 684: l_cen VARCHAR2(30) := 'HZ_PERSON_INTEREST';

680: l_parent_id NUMBER; -- used to store parent entity identifier
681: l_child_id NUMBER; -- used to store HZ_PERSON_INTEREST identifier
682: l_lud DATE; -- used to store the child last update date
683: l_child_rec_exists_no NUMBER;
684: l_cen VARCHAR2(30) := 'HZ_PERSON_INTEREST';
685: BEGIN
686: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_interest+',
687: p_prefix=>l_debug_prefix,
688: p_msg_level=>fnd_log.level_procedure);

Line 686: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_interest+',

682: l_lud DATE; -- used to store the child last update date
683: l_child_rec_exists_no NUMBER;
684: l_cen VARCHAR2(30) := 'HZ_PERSON_INTEREST';
685: BEGIN
686: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_interest+',
687: p_prefix=>l_debug_prefix,
688: p_msg_level=>fnd_log.level_procedure);
689:
690: -- validate p_operation

Line 694: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_interest',

690: -- validate p_operation
691: IF p_operation IN ('I','U') THEN
692: NULL;
693: ELSE
694: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_interest',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;

Line 728: 'N', p_operation, l_child_id, 'HZ_PERSON_INTEREST', NULL,

724: INSERT INTO HZ_BUS_OBJ_TRACKING
725: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
726: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
727: ) VALUES (
728: 'N', p_operation, l_child_id, 'HZ_PERSON_INTEREST', NULL,
729: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
730:
731: -- populate party record
732: pop_parent_record(p_child_id => l_parent_id,

Line 742: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_interest-',

738: p_pbo_code => NULL);
739: END ; -- anonymous block end
740: END LOOP;
741:
742: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_interest-',
743: p_prefix=>l_debug_prefix,
744: p_msg_level=>fnd_log.level_procedure);
745: EXCEPTION
746: WHEN OTHERS THEN

Line 751: END pop_hz_person_interest;

747: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
748: p_prefix=>l_debug_prefix,
749: p_msg_level=>fnd_log.level_procedure);
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END pop_hz_person_interest;
752:
753: -----------------------------------------------------------------
754: -- Procedure name: pop_hz_party_site_uses()
755: -- Purpose: populates BOT for HZ_PARTY_SITE_USES create or update