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_CONTACTS

Line 338: FROM HZ_ORG_CONTACTS

334: AND object_type in ('ORGANIZATION','PERSON');
335:
336: CURSOR c_get_oc_id IS
337: SELECT org_contact_id
338: FROM HZ_ORG_CONTACTS
339: WHERE party_relationship_id = p_relationship_id;
340:
341: -- local variables
342: l_debug_prefix VARCHAR2(40) := 'pop_hz_relationships';

Line 431: pop_hz_org_contacts(

427: IF(l_sbo_code = 'PERSON' AND l_obo_code = 'ORGANIZATION') THEN
428: OPEN c_get_oc_id;
429: FETCH c_get_oc_id INTO l_oc_id;
430: CLOSE c_get_oc_id;
431: pop_hz_org_contacts(
432: p_operation => 'U',
433: p_org_contact_id => l_oc_id);
434: END IF;
435: END IF;

Line 783: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

779: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
780:
781: CURSOR get_org_contact(l_party_id NUMBER) IS
782: SELECT oc.org_contact_id
783: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
784: WHERE oc.party_relationship_id = pr.relationship_id
785: AND pr.party_id = l_party_id
786: AND pr.subject_type = 'PERSON'
787: AND pr.object_type = 'ORGANIZATION'

Line 894: decode(p.party_type, 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', 'HZ_PARTIES') parent_tbl_name,

890:
891: -- cursor statement to select the info from child table
892: CURSOR c_child IS
893: SELECT ps.LAST_UPDATE_DATE lud, ps.PARTY_ID parent_id,
894: decode(p.party_type, 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', 'HZ_PARTIES') parent_tbl_name,
895: ps.PARTY_SITE_ID child_id,
896: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', null) bo_code,
897: ps.location_id location_id
898: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

Line 905: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

901: AND p.party_type in ('ORGANIZATION','PERSON','PARTY_RELATIONSHIP');
902:
903: CURSOR get_org_contact(l_party_id NUMBER) IS
904: SELECT oc.org_contact_id
905: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
906: WHERE oc.party_relationship_id = pr.relationship_id
907: AND pr.party_id = l_party_id
908: AND pr.subject_type = 'PERSON'
909: AND pr.object_type = 'ORGANIZATION'

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 1189: l_lud, l_lud, 'HZ_ORG_CONTACTS', l_parent_id, 'ORG_CONTACT');

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,
1193: p_lud => l_lud,

Line 1194: p_centity_name => 'HZ_ORG_CONTACTS',

1190:
1191: -- populate org party record
1192: pop_parent_record(p_child_id => l_parent_id,
1193: p_lud => l_lud,
1194: p_centity_name => 'HZ_ORG_CONTACTS',
1195: p_cbo_code => 'ORG_CONTACT',
1196: p_parent_id => l_org_id,
1197: p_pentity_name => 'HZ_PARTIES',
1198: p_pbo_code => 'ORG');

Line 1214: -- Procedure name: pop_hz_org_contacts()

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
1216: -- Scope: internal
1217: -- Called From: V2 API
1218: -- Called By: HZ_ORG_CONTACTS create or update APIs

Line 1215: -- Purpose: populates BOT for HZ_ORG_CONTACTS create or update

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
1216: -- Scope: internal
1217: -- Called From: V2 API
1218: -- Called By: HZ_ORG_CONTACTS create or update APIs
1219: -- Input Parameters:

Line 1218: -- Called By: HZ_ORG_CONTACTS create or update APIs

1214: -- Procedure name: pop_hz_org_contacts()
1215: -- Purpose: populates BOT for HZ_ORG_CONTACTS create or update
1216: -- Scope: internal
1217: -- Called From: V2 API
1218: -- Called By: HZ_ORG_CONTACTS create or update APIs
1219: -- Input Parameters:
1220: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1221: -- p_org_contact_id IN NUMBER
1222: --

Line 1224: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORG_CONTACTS

1220: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1221: -- p_org_contact_id IN NUMBER
1222: --
1223: -- Note:
1224: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORG_CONTACTS
1225: -- This procedure must ensure that the combination is valid before populating BOT
1226: --
1227: -- PARENT BO: ORG :: CHILD BO: ORG_CONTACT
1228: -----------------------------------------------------------------

Line 1229: PROCEDURE pop_hz_org_contacts(p_operation IN VARCHAR2, p_org_contact_id IN NUMBER) IS

1225: -- This procedure must ensure that the combination is valid before populating BOT
1226: --
1227: -- PARENT BO: ORG :: CHILD BO: ORG_CONTACT
1228: -----------------------------------------------------------------
1229: PROCEDURE pop_hz_org_contacts(p_operation IN VARCHAR2, p_org_contact_id IN NUMBER) IS
1230:
1231: -- cursor statement to select the info from child table
1232: CURSOR C_child IS
1233: SELECT oc.LAST_UPDATE_DATE lud, oc.ORG_CONTACT_ID child_id,

Line 1235: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

1231: -- cursor statement to select the info from child table
1232: CURSOR C_child IS
1233: SELECT oc.LAST_UPDATE_DATE lud, oc.ORG_CONTACT_ID child_id,
1234: pr.object_id parent_id, pr.subject_id person_id, pr.relationship_id rel_id
1235: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
1236: WHERE oc.ORG_CONTACT_ID = P_ORG_CONTACT_ID
1237: AND oc.party_relationship_id = pr.relationship_id
1238: AND pr.object_type = 'ORGANIZATION'
1239: AND pr.subject_type = 'PERSON'

Line 1243: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contacts';

1239: AND pr.subject_type = 'PERSON'
1240: AND rownum = 1;
1241:
1242: -- local variables
1243: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contacts';
1244: l_parent_id NUMBER; -- used to store parent entity identifier
1245: l_child_id NUMBER; -- used to store HZ_ORG_CONTACTS identifier
1246: l_lud DATE; -- used to store the child last update date
1247: l_child_rec_exists_no NUMBER;

Line 1245: l_child_id NUMBER; -- used to store HZ_ORG_CONTACTS identifier

1241:
1242: -- local variables
1243: l_debug_prefix VARCHAR2(40) := 'pop_hz_org_contacts';
1244: l_parent_id NUMBER; -- used to store parent entity identifier
1245: l_child_id NUMBER; -- used to store HZ_ORG_CONTACTS identifier
1246: l_lud DATE; -- used to store the child last update date
1247: l_child_rec_exists_no NUMBER;
1248: l_rel_id NUMBER;
1249: l_person_id NUMBER;

Line 1251: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACTS';

1247: l_child_rec_exists_no NUMBER;
1248: l_rel_id NUMBER;
1249: l_person_id NUMBER;
1250: l_pop_flag VARCHAR2(1);
1251: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACTS';
1252: BEGIN
1253: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contacts+',
1254: p_prefix=>l_debug_prefix,
1255: p_msg_level=>fnd_log.level_procedure);

Line 1253: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contacts+',

1249: l_person_id NUMBER;
1250: l_pop_flag VARCHAR2(1);
1251: l_cen VARCHAR2(30) := 'HZ_ORG_CONTACTS';
1252: BEGIN
1253: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contacts+',
1254: p_prefix=>l_debug_prefix,
1255: p_msg_level=>fnd_log.level_procedure);
1256:
1257: -- validate p_operation

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

1257: -- validate p_operation
1258: IF p_operation IN ('I','U') THEN
1259: NULL;
1260: ELSE
1261: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_org_contacts',
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_procedure);
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;

Line 1305: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACTS', 'ORG_CONTACT',

1301: INSERT INTO HZ_BUS_OBJ_TRACKING
1302: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1303: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1304: ) VALUES (
1305: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACTS', 'ORG_CONTACT',
1306: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
1307:
1308: -- populate subject person as child
1309: pop_parent_record(p_child_id => l_person_id,

Line 1314: p_pentity_name => 'HZ_ORG_CONTACTS',

1310: p_lud => l_lud,
1311: p_centity_name => 'HZ_PARTIES',
1312: p_cbo_code => 'PERSON_CONTACT',
1313: p_parent_id => l_child_id,
1314: p_pentity_name => 'HZ_ORG_CONTACTS',
1315: p_pbo_code => 'ORG_CONTACT');
1316:
1317: -- populate relationship as child
1318: pop_parent_record(p_child_id => l_rel_id,

Line 1323: p_pentity_name => 'HZ_ORG_CONTACTS',

1319: p_lud => l_lud,
1320: p_centity_name => 'HZ_RELATIONSHIPS',
1321: p_cbo_code => NULL,
1322: p_parent_id => l_child_id,
1323: p_pentity_name => 'HZ_ORG_CONTACTS',
1324: p_pbo_code => 'ORG_CONTACT');
1325: END ; -- anonymous block end
1326: END LOOP;
1327:

Line 1328: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contacts-',

1324: p_pbo_code => 'ORG_CONTACT');
1325: END ; -- anonymous block end
1326: END LOOP;
1327:
1328: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_org_contacts-',
1329: p_prefix=>l_debug_prefix,
1330: p_msg_level=>fnd_log.level_procedure);
1331: EXCEPTION
1332: WHEN OTHERS THEN

Line 1337: END pop_hz_org_contacts;

1333: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1334: p_prefix=>l_debug_prefix,
1335: p_msg_level=>fnd_log.level_procedure);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END pop_hz_org_contacts;
1338:
1339: -----------------------------------------------------------------
1340: -- Procedure name: pop_hz_organization_profiles()
1341: -- Purpose: populates BOT for HZ_ORGANIZATION_PROFILES create or update

Line 3031: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)

3027: AND contact_point_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EFT', 'EDI', 'SMS');
3028:
3029: CURSOR c_pty(p_parent_id NUMBER) IS
3030: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3031: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3032: FROM HZ_PARTIES
3033: WHERE party_id = p_parent_id
3034: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3035:

Line 3038: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc

3034: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3035:
3036: CURSOR c_oc(p_parent_id NUMBER) IS
3037: SELECT oc.org_contact_id
3038: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
3039: WHERE r.relationship_id = oc.party_relationship_id
3040: AND r.subject_type = 'PERSON'
3041: AND r.object_type = 'ORGANIZATION'
3042: AND r.party_id = p_parent_id

Line 3211: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)

3207:
3208: -- cursor statement to select the info from party parent table
3209: CURSOR c_party_parent(p_parent_id IN NUMBER) IS
3210: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3211: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3212: FROM HZ_PARTIES
3213: WHERE PARTY_ID = p_parent_id
3214: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3215:

Line 3218: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc

3214: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3215:
3216: CURSOR c_oc(p_parent_id NUMBER) IS
3217: SELECT oc.org_contact_id
3218: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
3219: WHERE r.relationship_id = oc.party_relationship_id
3220: AND r.subject_type = 'PERSON'
3221: AND r.object_type = 'ORGANIZATION'
3222: AND r.party_id = p_parent_id