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_PARTY_PREFERENCES

Line 999: -- Procedure name: pop_hz_party_preferences()

995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END pop_hz_party_sites;
997:
998: -----------------------------------------------------------------
999: -- Procedure name: pop_hz_party_preferences()
1000: -- Purpose: populates BOT for HZ_PARTY_PREFERENCES create or update
1001: -- Scope: internal
1002: -- Called From: V2 API
1003: -- Called By: HZ_PARTY_PREFERENCES create or update APIs

Line 1000: -- Purpose: populates BOT for HZ_PARTY_PREFERENCES create or update

996: END pop_hz_party_sites;
997:
998: -----------------------------------------------------------------
999: -- Procedure name: pop_hz_party_preferences()
1000: -- Purpose: populates BOT for HZ_PARTY_PREFERENCES create or update
1001: -- Scope: internal
1002: -- Called From: V2 API
1003: -- Called By: HZ_PARTY_PREFERENCES create or update APIs
1004: -- Input Parameters:

Line 1003: -- Called By: HZ_PARTY_PREFERENCES create or update APIs

999: -- Procedure name: pop_hz_party_preferences()
1000: -- Purpose: populates BOT for HZ_PARTY_PREFERENCES create or update
1001: -- Scope: internal
1002: -- Called From: V2 API
1003: -- Called By: HZ_PARTY_PREFERENCES create or update APIs
1004: -- Input Parameters:
1005: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1006: -- p_party_preference_id IN NUMBER
1007: --

Line 1009: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PARTY_PREFERENCES

1005: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1006: -- p_party_preference_id IN NUMBER
1007: --
1008: -- Note:
1009: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PARTY_PREFERENCES
1010: -- This procedure must ensure that the combination is valid before populating BOT
1011: --
1012: -- PARENT BO: ORG :: CHILD BO:
1013: -- PARENT BO: PERSON :: CHILD BO:

Line 1015: PROCEDURE pop_hz_party_preferences(p_operation IN VARCHAR2, p_party_preference_id IN NUMBER) IS

1011: --
1012: -- PARENT BO: ORG :: CHILD BO:
1013: -- PARENT BO: PERSON :: CHILD BO:
1014: -----------------------------------------------------------------
1015: PROCEDURE pop_hz_party_preferences(p_operation IN VARCHAR2, p_party_preference_id IN NUMBER) IS
1016:
1017: CURSOR C_child IS
1018: SELECT pp.LAST_UPDATE_DATE lud, pp.PARTY_ID parent_id,
1019: 'HZ_PARTIES' parent_tbl_name, pp.PARTY_PREFERENCE_ID child_id,

Line 1021: FROM HZ_PARTY_PREFERENCES pp, HZ_PARTIES p

1017: CURSOR C_child IS
1018: SELECT pp.LAST_UPDATE_DATE lud, pp.PARTY_ID parent_id,
1019: 'HZ_PARTIES' parent_tbl_name, pp.PARTY_PREFERENCE_ID child_id,
1020: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
1021: FROM HZ_PARTY_PREFERENCES pp, HZ_PARTIES p
1022: WHERE pp.PARTY_PREFERENCE_ID = p_party_preference_id
1023: AND pp.party_id = p.party_id
1024: AND p.party_type in ('ORGANIZATION', 'PERSON');
1025:

Line 1027: l_debug_prefix VARCHAR2(40) := 'pop_hz_party_preferences';

1023: AND pp.party_id = p.party_id
1024: AND p.party_type in ('ORGANIZATION', 'PERSON');
1025:
1026: -- local variables
1027: l_debug_prefix VARCHAR2(40) := 'pop_hz_party_preferences';
1028: l_parent_id NUMBER; -- used to store parent entity identifier
1029: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
1030: l_bo_code VARCHAR2(30); -- used to store BO Code
1031: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)

Line 1032: l_child_id NUMBER; -- used to store HZ_PARTY_PREFERENCES identifier

1028: l_parent_id NUMBER; -- used to store parent entity identifier
1029: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
1030: l_bo_code VARCHAR2(30); -- used to store BO Code
1031: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
1032: l_child_id NUMBER; -- used to store HZ_PARTY_PREFERENCES identifier
1033: l_lud DATE; -- used to store the child last update date
1034: l_child_rec_exists_no NUMBER;
1035: l_cen VARCHAR2(30) := 'HZ_PARTY_PREFERENCES';
1036: BEGIN

Line 1035: l_cen VARCHAR2(30) := 'HZ_PARTY_PREFERENCES';

1031: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
1032: l_child_id NUMBER; -- used to store HZ_PARTY_PREFERENCES identifier
1033: l_lud DATE; -- used to store the child last update date
1034: l_child_rec_exists_no NUMBER;
1035: l_cen VARCHAR2(30) := 'HZ_PARTY_PREFERENCES';
1036: BEGIN
1037: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_preferences+',
1038: p_prefix=>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_procedure);

Line 1037: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_preferences+',

1033: l_lud DATE; -- used to store the child last update date
1034: l_child_rec_exists_no NUMBER;
1035: l_cen VARCHAR2(30) := 'HZ_PARTY_PREFERENCES';
1036: BEGIN
1037: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_preferences+',
1038: p_prefix=>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_procedure);
1040:
1041: -- validate p_operation

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

1041: -- validate p_operation
1042: IF p_operation IN ('I','U') THEN
1043: NULL;
1044: ELSE
1045: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_party_preferences',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;

Line 1081: 'N', p_operation, l_child_id, 'HZ_PARTY_PREFERENCES', NULL,

1077: INSERT INTO HZ_BUS_OBJ_TRACKING
1078: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1079: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1080: ) VALUES (
1081: 'N', p_operation, l_child_id, 'HZ_PARTY_PREFERENCES', NULL,
1082: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
1083:
1084: -- populate party record
1085: pop_parent_record(p_child_id => l_parent_id,

Line 1095: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_preferences-',

1091: p_pbo_code => NULL);
1092: END ; -- anonymous block end
1093: END LOOP;
1094:
1095: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_preferences-',
1096: p_prefix=>l_debug_prefix,
1097: p_msg_level=>fnd_log.level_procedure);
1098: EXCEPTION
1099: WHEN OTHERS THEN

Line 1104: END pop_hz_party_preferences;

1100: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1101: p_prefix=>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_procedure);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END pop_hz_party_preferences;
1105:
1106: -----------------------------------------------------------------
1107: -- Procedure name: pop_hz_org_contact_roles()
1108: -- Purpose: populates BOT for HZ_ORG_CONTACT_ROLES create or update