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_ORG_CONTACT_ROLES

Line 1107: -- Procedure name: pop_hz_org_contact_roles()

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
1109: -- Scope: internal
1110: -- Called From: V2 API
1111: -- Called By: HZ_ORG_CONTACT_ROLES create or update APIs

Line 1108: -- Purpose: populates BOT for HZ_ORG_CONTACT_ROLES create or update

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
1109: -- Scope: internal
1110: -- Called From: V2 API
1111: -- Called By: HZ_ORG_CONTACT_ROLES create or update APIs
1112: -- Input Parameters:

Line 1111: -- Called By: HZ_ORG_CONTACT_ROLES create or update APIs

1107: -- Procedure name: pop_hz_org_contact_roles()
1108: -- Purpose: populates BOT for HZ_ORG_CONTACT_ROLES create or update
1109: -- Scope: internal
1110: -- Called From: V2 API
1111: -- Called By: HZ_ORG_CONTACT_ROLES create or update APIs
1112: -- Input Parameters:
1113: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1114: -- p_org_contact_role_id IN NUMBER
1115: --

Line 1117: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORG_CONTACT_ROLES

1113: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1114: -- p_org_contact_role_id IN NUMBER
1115: --
1116: -- Note:
1117: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORG_CONTACT_ROLES
1118: -- This procedure must ensure that the combination is valid before populating BOT
1119: --
1120: -- PARENT BO: ORG_CONTACT :: CHILD BO:
1121: -----------------------------------------------------------------

Line 1122: PROCEDURE pop_hz_org_contact_roles(p_operation IN VARCHAR2, p_org_contact_role_id IN NUMBER) IS

1118: -- This procedure must ensure that the combination is valid before populating BOT
1119: --
1120: -- PARENT BO: ORG_CONTACT :: CHILD BO:
1121: -----------------------------------------------------------------
1122: PROCEDURE pop_hz_org_contact_roles(p_operation IN VARCHAR2, p_org_contact_role_id IN NUMBER) IS
1123:
1124: -- cursor statement to select the info from child table
1125: CURSOR C_child IS
1126: SELECT ocr.LAST_UPDATE_DATE lud, ocr.ORG_CONTACT_ID parent_id,

Line 1128: FROM HZ_ORG_CONTACT_ROLES ocr, HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

1124: -- cursor statement to select the info from child table
1125: CURSOR C_child IS
1126: SELECT ocr.LAST_UPDATE_DATE lud, ocr.ORG_CONTACT_ID parent_id,
1127: ocr.ORG_CONTACT_ROLE_ID child_id, pr.object_id object_id
1128: FROM HZ_ORG_CONTACT_ROLES ocr, HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
1129: WHERE ORG_CONTACT_ROLE_ID = P_ORG_CONTACT_ROLE_ID
1130: AND ocr.org_contact_id = oc.org_contact_id
1131: AND oc.party_relationship_id = pr.relationship_id
1132: AND pr.object_type = 'ORGANIZATION'

Line 1137: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contact_roles';

1133: AND pr.subject_type = 'PERSON'
1134: AND rownum = 1;
1135:
1136: -- local variables
1137: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contact_roles';
1138: l_parent_id NUMBER; -- used to store parent entity identifier
1139: l_child_id NUMBER; -- used to store HZ_ORG_CONTACT_ROLES identifier
1140: l_lud DATE; -- used to store the child last update date
1141: l_child_rec_exists_no NUMBER;

Line 1139: l_child_id NUMBER; -- used to store HZ_ORG_CONTACT_ROLES identifier

1135:
1136: -- local variables
1137: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contact_roles';
1138: l_parent_id NUMBER; -- used to store parent entity identifier
1139: l_child_id NUMBER; -- used to store HZ_ORG_CONTACT_ROLES identifier
1140: l_lud DATE; -- used to store the child last update date
1141: l_child_rec_exists_no NUMBER;
1142: l_org_id NUMBER;
1143: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACT_ROLES';

Line 1143: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACT_ROLES';

1139: l_child_id NUMBER; -- used to store HZ_ORG_CONTACT_ROLES identifier
1140: l_lud DATE; -- used to store the child last update date
1141: l_child_rec_exists_no NUMBER;
1142: l_org_id NUMBER;
1143: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACT_ROLES';
1144: BEGIN
1145: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contact_roles+',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);

Line 1145: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contact_roles+',

1141: l_child_rec_exists_no NUMBER;
1142: l_org_id NUMBER;
1143: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACT_ROLES';
1144: BEGIN
1145: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contact_roles+',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148:
1149: -- validate p_operation

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

1149: -- validate p_operation
1150: IF p_operation IN ('I','U') THEN
1151: NULL;
1152: ELSE
1153: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_org_contact_roles',
1154: p_prefix=>l_debug_prefix,
1155: p_msg_level=>fnd_log.level_procedure);
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;

Line 1188: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACT_ROLES', NULL,

1184: INSERT INTO HZ_BUS_OBJ_TRACKING
1185: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1186: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1187: ) VALUES (
1188: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACT_ROLES', NULL,
1189: l_lud, l_lud, 'HZ_ORG_CONTACTS', l_parent_id, 'ORG_CONTACT');
1190:
1191: -- populate org party record
1192: pop_parent_record(p_child_id => l_parent_id,

Line 1202: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contact_roles-',

1198: p_pbo_code => 'ORG');
1199: END ; -- anonymous block end
1200: END LOOP;
1201:
1202: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contact_roles-',
1203: p_prefix=>l_debug_prefix,
1204: p_msg_level=>fnd_log.level_procedure);
1205: EXCEPTION
1206: WHEN OTHERS THEN

Line 1211: END pop_hz_org_contact_roles;

1207: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1208: p_prefix=>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_procedure);
1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1211: END pop_hz_org_contact_roles;
1212:
1213: -----------------------------------------------------------------
1214: -- Procedure name: pop_hz_org_contacts()
1215: -- Purpose: populates BOT for HZ_ORG_CONTACTS create or update