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_SITES

Line 775: FROM HZ_PARTY_SITE_USES psu, HZ_PARTY_SITES ps, HZ_PARTIES p

771: -- cursor statement to select the info from child table
772: CURSOR C_child IS
773: SELECT psu.LAST_UPDATE_DATE lud, psu.PARTY_SITE_ID parent_id, psu.PARTY_SITE_USE_ID child_id,
774: p.party_type, p.party_id
775: FROM HZ_PARTY_SITE_USES psu, HZ_PARTY_SITES ps, HZ_PARTIES p
776: WHERE psu.PARTY_SITE_USE_ID = P_PARTY_SITE_USE_ID
777: AND psu.party_site_id = ps.party_site_id
778: AND ps.party_id = p.party_id
779: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');

Line 856: l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');

852: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
853: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
854: ) VALUES (
855: 'N', p_operation, l_child_id, 'HZ_PARTY_SITE_USES', NULL,
856: l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');
857: END ; -- anonymous block end
858: END LOOP;
859:
860: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_site_uses-',

Line 872: -- Procedure name: pop_hz_party_sites()

868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END pop_hz_party_site_uses;
870:
871: -----------------------------------------------------------------
872: -- Procedure name: pop_hz_party_sites()
873: -- Purpose: populates BOT for HZ_PARTY_SITES create or update
874: -- Scope: internal
875: -- Called From: V2 API
876: -- Called By: HZ_PARTY_SITES create or update APIs

Line 873: -- Purpose: populates BOT for HZ_PARTY_SITES create or update

869: END pop_hz_party_site_uses;
870:
871: -----------------------------------------------------------------
872: -- Procedure name: pop_hz_party_sites()
873: -- Purpose: populates BOT for HZ_PARTY_SITES create or update
874: -- Scope: internal
875: -- Called From: V2 API
876: -- Called By: HZ_PARTY_SITES create or update APIs
877: -- Input Parameters:

Line 876: -- Called By: HZ_PARTY_SITES create or update APIs

872: -- Procedure name: pop_hz_party_sites()
873: -- Purpose: populates BOT for HZ_PARTY_SITES create or update
874: -- Scope: internal
875: -- Called From: V2 API
876: -- Called By: HZ_PARTY_SITES create or update APIs
877: -- Input Parameters:
878: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
879: -- p_party_site_id IN NUMBER
880: --

Line 882: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PARTY_SITES

878: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
879: -- p_party_site_id IN NUMBER
880: --
881: -- Note:
882: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PARTY_SITES
883: -- This procedure must ensure that the combination is valid before populating BOT
884: --
885: -- PARENT BO: ORG :: CHILD BO: PARTY_SITE
886: -- PARENT BO: PERSON :: CHILD BO: PARTY_SITE

Line 889: PROCEDURE pop_hz_party_sites(p_operation IN VARCHAR2, p_party_site_id IN NUMBER) IS

885: -- PARENT BO: ORG :: CHILD BO: PARTY_SITE
886: -- PARENT BO: PERSON :: CHILD BO: PARTY_SITE
887: -- PARENT BO: ORG_CONTACT :: CHILD BO: PARTY_SITE
888: -----------------------------------------------------------------
889: PROCEDURE pop_hz_party_sites(p_operation IN VARCHAR2, p_party_site_id IN NUMBER) IS
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,

Line 898: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

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
899: WHERE ps.PARTY_SITE_ID = P_PARTY_SITE_ID
900: AND ps.party_id = p.party_id
901: AND p.party_type in ('ORGANIZATION','PERSON','PARTY_RELATIONSHIP');
902:

Line 913: l_debug_prefix VARCHAR2(40) := 'pop_hz_party_sites';

909: AND pr.object_type = 'ORGANIZATION'
910: AND rownum = 1;
911:
912: -- local variables
913: l_debug_prefix VARCHAR2(40) := 'pop_hz_party_sites';
914: l_parent_id NUMBER; -- used to store parent entity identifier
915: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
916: l_bo_code VARCHAR2(30); -- used to store BO Code
917: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)

Line 918: l_child_id NUMBER; -- used to store HZ_PARTY_SITES identifier

914: l_parent_id NUMBER; -- used to store parent entity identifier
915: l_parent_tbl_name VARCHAR2(30); -- used to store parent entity name
916: l_bo_code VARCHAR2(30); -- used to store BO Code
917: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
918: l_child_id NUMBER; -- used to store HZ_PARTY_SITES identifier
919: l_lud DATE; -- used to store the child last update date
920: l_child_rec_exists_no NUMBER;
921: l_location_id NUMBER;
922: l_org_contact_id NUMBER;

Line 924: l_cen VARCHAR2(30) := 'HZ_PARTY_SITES';

920: l_child_rec_exists_no NUMBER;
921: l_location_id NUMBER;
922: l_org_contact_id NUMBER;
923: l_org_id NUMBER; -- party_id of organization for org contact relationship
924: l_cen VARCHAR2(30) := 'HZ_PARTY_SITES';
925: BEGIN
926: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_sites+',
927: p_prefix=>l_debug_prefix,
928: p_msg_level=>fnd_log.level_procedure);

Line 926: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_sites+',

922: l_org_contact_id NUMBER;
923: l_org_id NUMBER; -- party_id of organization for org contact relationship
924: l_cen VARCHAR2(30) := 'HZ_PARTY_SITES';
925: BEGIN
926: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_sites+',
927: p_prefix=>l_debug_prefix,
928: p_msg_level=>fnd_log.level_procedure);
929:
930: -- validate p_operation

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

930: -- validate p_operation
931: IF p_operation IN ('I','U') THEN
932: NULL;
933: ELSE
934: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_party_sites',
935: p_prefix=>l_debug_prefix,
936: p_msg_level=>fnd_log.level_procedure);
937: RAISE FND_API.G_EXC_ERROR;
938: END IF;

Line 982: 'N', p_operation, l_child_id, 'HZ_PARTY_SITES', 'PARTY_SITE',

978: INSERT INTO HZ_BUS_OBJ_TRACKING
979: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
980: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
981: ) VALUES (
982: 'N', p_operation, l_child_id, 'HZ_PARTY_SITES', 'PARTY_SITE',
983: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
984: END ; -- anonymous block end
985: END LOOP;
986:

Line 987: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_sites-',

983: l_lud, l_lud, l_parent_tbl_name, l_parent_id, l_bo_code);
984: END ; -- anonymous block end
985: END LOOP;
986:
987: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_party_sites-',
988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: EXCEPTION
991: WHEN OTHERS THEN

Line 996: END pop_hz_party_sites;

992: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
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

Line 1463: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

1459: WHERE location_id = p_location_id;
1460:
1461: CURSOR c_ps(l_loc_id NUMBER) IS
1462: SELECT party_site_id
1463: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
1464: WHERE ps.location_id = l_loc_id
1465: AND ps.party_id = p.party_id;
1466:
1467: -- local variables

Line 1524: l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');

1520: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1521: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1522: ) VALUES (
1523: 'N', p_operation, l_child_id, 'HZ_LOCATIONS', 'LOCATION',
1524: l_lud, l_lud, 'HZ_PARTY_SITES', l_parent_id, 'PARTY_SITE');
1525: END LOOP;
1526: CLOSE c_ps;
1527: END ; -- anonymous block end
1528: END LOOP;

Line 3082: IF(l_parent_tbl_name = 'HZ_PARTY_SITES') THEN

3078: l_child_id := c_child_rec.child_id;
3079: l_parent_id := c_child_rec.parent_id;
3080: l_parent_tbl_name := c_child_rec.parent_tbl_name;
3081:
3082: IF(l_parent_tbl_name = 'HZ_PARTY_SITES') THEN
3083: l_bo_code := 'PARTY_SITE';
3084: IF NOT(is_valid_ps(l_parent_id)) THEN
3085: RETURN;
3086: END IF;

Line 3206: AND OWNER_TABLE_NAME in ('HZ_PARTY_SITES', 'HZ_PARTIES');

3202: SELECT LAST_UPDATE_DATE lud, OWNER_TABLE_ID parent_id, CONTACT_POINT_ID child_id,
3203: OWNER_TABLE_NAME parent_entity, CONTACT_POINT_TYPE child_bo_code
3204: FROM HZ_CONTACT_POINTS
3205: WHERE CONTACT_POINT_ID = P_CONTACT_POINT_ID
3206: AND OWNER_TABLE_NAME in ('HZ_PARTY_SITES', 'HZ_PARTIES');
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),

Line 3259: IF(l_parent_tbl_name = 'HZ_PARTY_SITES') THEN

3255: l_child_bo_code := c_child_rec.child_bo_code;
3256: l_parent_id := c_child_rec.parent_id;
3257: l_parent_tbl_name := c_child_rec.parent_entity;
3258:
3259: IF(l_parent_tbl_name = 'HZ_PARTY_SITES') THEN
3260: l_bo_code := 'PARTY_SITE';
3261: ELSIF(l_parent_tbl_name = 'HZ_PARTIES') THEN
3262: OPEN c_party_parent(l_parent_id);
3263: FETCH c_party_parent INTO l_bo_code, l_parent_tbl_name;

Line 3793: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_SITE_ID parent_id, c.extension_id child_id, 'PARTY_SITE' bo_code, 'HZ_PARTY_SITES' parent_entity

3789: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3790: AND rownum = 1;
3791:
3792: CURSOR C_child_ps IS
3793: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_SITE_ID parent_id, c.extension_id child_id, 'PARTY_SITE' bo_code, 'HZ_PARTY_SITES' parent_entity
3794: FROM HZ_PARTY_SITES_EXT_B c
3795: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3796: AND rownum = 1;
3797:

Line 3794: FROM HZ_PARTY_SITES_EXT_B c

3790: AND rownum = 1;
3791:
3792: CURSOR C_child_ps IS
3793: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_SITE_ID parent_id, c.extension_id child_id, 'PARTY_SITE' bo_code, 'HZ_PARTY_SITES' parent_entity
3794: FROM HZ_PARTY_SITES_EXT_B c
3795: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3796: AND rownum = 1;
3797:
3798: -- local variables

Line 3833: l_child_entity := 'HZ_PARTY_SITES_EXT_VL';

3829: OPEN c_child_loc;
3830: l_child_entity := 'HZ_LOCATIONS_EXT_VL';
3831: ELSIF(p_object_type = 'PARTY_SITE') THEN
3832: OPEN c_child_ps;
3833: l_child_entity := 'HZ_PARTY_SITES_EXT_VL';
3834: END IF;
3835:
3836: IF(p_object_type = 'ORG') THEN
3837: FETCH c_child_org INTO l_lud, l_parent_id, l_child_id, l_bo_code, l_parent_entity;

Line 4017: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

4013: p_party_site_id IN NUMBER
4014: ) RETURN BOOLEAN IS
4015: CURSOR get_ps IS
4016: SELECT p.party_type, p.party_id
4017: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
4018: WHERE ps.party_site_id = p_party_site_id
4019: AND ps.party_id = p.party_id
4020: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
4021: