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_ORGANIZATION_PROFILES

Line 1340: -- Procedure name: pop_hz_organization_profiles()

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
1342: -- Scope: internal
1343: -- Called From: V2 API
1344: -- Called By: HZ_ORGANIZATION_PROFILES create or update APIs

Line 1341: -- Purpose: populates BOT for HZ_ORGANIZATION_PROFILES create or update

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
1342: -- Scope: internal
1343: -- Called From: V2 API
1344: -- Called By: HZ_ORGANIZATION_PROFILES create or update APIs
1345: -- Input Parameters:

Line 1344: -- Called By: HZ_ORGANIZATION_PROFILES create or update APIs

1340: -- Procedure name: pop_hz_organization_profiles()
1341: -- Purpose: populates BOT for HZ_ORGANIZATION_PROFILES create or update
1342: -- Scope: internal
1343: -- Called From: V2 API
1344: -- Called By: HZ_ORGANIZATION_PROFILES create or update APIs
1345: -- Input Parameters:
1346: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1347: -- p_organization_profile_id IN NUMBER
1348: --

Line 1350: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORGANIZATION_PROFILES

1346: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1347: -- p_organization_profile_id IN NUMBER
1348: --
1349: -- Note:
1350: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ORGANIZATION_PROFILES
1351: -- This procedure must ensure that the combination is valid before populating BOT
1352: --
1353: -- PARENT BO: ORG :: CHILD BO:
1354: -----------------------------------------------------------------

Line 1355: PROCEDURE pop_hz_organization_profiles(p_operation IN VARCHAR2, p_organization_profile_id IN NUMBER) IS

1351: -- This procedure must ensure that the combination is valid before populating BOT
1352: --
1353: -- PARENT BO: ORG :: CHILD BO:
1354: -----------------------------------------------------------------
1355: PROCEDURE pop_hz_organization_profiles(p_operation IN VARCHAR2, p_organization_profile_id IN NUMBER) IS
1356:
1357: -- cursor statement to select the info from child table
1358: CURSOR C_child IS
1359: SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, ORGANIZATION_PROFILE_ID child_id

Line 1360: FROM HZ_ORGANIZATION_PROFILES

1356:
1357: -- cursor statement to select the info from child table
1358: CURSOR C_child IS
1359: SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, ORGANIZATION_PROFILE_ID child_id
1360: FROM HZ_ORGANIZATION_PROFILES
1361: WHERE ORGANIZATION_PROFILE_ID = P_ORGANIZATION_PROFILE_ID;
1362:
1363: -- local variables
1364: l_debug_prefix VARCHAR2(40) := 'pop_hz_organization_profiles';

Line 1364: l_debug_prefix VARCHAR2(40) := 'pop_hz_organization_profiles';

1360: FROM HZ_ORGANIZATION_PROFILES
1361: WHERE ORGANIZATION_PROFILE_ID = P_ORGANIZATION_PROFILE_ID;
1362:
1363: -- local variables
1364: l_debug_prefix VARCHAR2(40) := 'pop_hz_organization_profiles';
1365: l_parent_id NUMBER; -- used to store parent entity identifier
1366: l_child_id NUMBER; -- used to store HZ_ORGANIZATION_PROFILES identifier
1367: l_lud DATE; -- used to store the child last update date
1368: l_child_rec_exists_no NUMBER;

Line 1366: l_child_id NUMBER; -- used to store HZ_ORGANIZATION_PROFILES identifier

1362:
1363: -- local variables
1364: l_debug_prefix VARCHAR2(40) := 'pop_hz_organization_profiles';
1365: l_parent_id NUMBER; -- used to store parent entity identifier
1366: l_child_id NUMBER; -- used to store HZ_ORGANIZATION_PROFILES identifier
1367: l_lud DATE; -- used to store the child last update date
1368: l_child_rec_exists_no NUMBER;
1369: l_cen VARCHAR2(30) := 'HZ_ORGANIZATION_PROFILES';
1370: BEGIN

Line 1369: l_cen VARCHAR2(30) := 'HZ_ORGANIZATION_PROFILES';

1365: l_parent_id NUMBER; -- used to store parent entity identifier
1366: l_child_id NUMBER; -- used to store HZ_ORGANIZATION_PROFILES identifier
1367: l_lud DATE; -- used to store the child last update date
1368: l_child_rec_exists_no NUMBER;
1369: l_cen VARCHAR2(30) := 'HZ_ORGANIZATION_PROFILES';
1370: BEGIN
1371: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_organization_profiles+',
1372: p_prefix=>l_debug_prefix,
1373: p_msg_level=>fnd_log.level_procedure);

Line 1371: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_organization_profiles+',

1367: l_lud DATE; -- used to store the child last update date
1368: l_child_rec_exists_no NUMBER;
1369: l_cen VARCHAR2(30) := 'HZ_ORGANIZATION_PROFILES';
1370: BEGIN
1371: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_organization_profiles+',
1372: p_prefix=>l_debug_prefix,
1373: p_msg_level=>fnd_log.level_procedure);
1374:
1375: -- validate p_operation

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

1375: -- validate p_operation
1376: IF p_operation IN ('I','U') THEN
1377: NULL;
1378: ELSE
1379: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_organization_profiles',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;

Line 1413: 'N', p_operation, l_child_id, 'HZ_ORGANIZATION_PROFILES', NULL,

1409: INSERT INTO HZ_BUS_OBJ_TRACKING
1410: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1411: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1412: ) VALUES (
1413: 'N', p_operation, l_child_id, 'HZ_ORGANIZATION_PROFILES', NULL,
1414: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
1415:
1416: -- populate org party record
1417: pop_parent_record(p_child_id => l_parent_id,

Line 1427: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_organization_profiles-',

1423: p_pbo_code => NULL);
1424: END ; -- anonymous block end
1425: END LOOP;
1426:
1427: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_organization_profiles-',
1428: p_prefix=>l_debug_prefix,
1429: p_msg_level=>fnd_log.level_procedure);
1430: EXCEPTION
1431: WHEN OTHERS THEN

Line 1436: END pop_hz_organization_profiles;

1432: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1433: p_prefix=>l_debug_prefix,
1434: p_msg_level=>fnd_log.level_procedure);
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END pop_hz_organization_profiles;
1437:
1438: -----------------------------------------------------------------
1439: -- Procedure name: pop_hz_locations()
1440: -- Purpose: populates BOT for HZ_LOCATIONS create or update

Line 3774: FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p

3770:
3771: -- cursor statement to select the info from child table
3772: CURSOR C_child_org IS
3773: SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'ORG' bo_code, 'HZ_PARTIES' parent_entity
3774: FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p
3775: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3776: AND c.ORGANIZATION_PROFILE_ID = p.ORGANIZATION_PROFILE_ID
3777: AND rownum = 1;
3778: