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_FINANCIAL_PROFILE

Line 1656: -- Procedure name: pop_hz_financial_profile()

1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END pop_hz_financial_reports;
1654:
1655: -----------------------------------------------------------------
1656: -- Procedure name: pop_hz_financial_profile()
1657: -- Purpose: populates BOT for HZ_FINANCIAL_PROFILE create or update
1658: -- Scope: internal
1659: -- Called From: V2 API
1660: -- Called By: HZ_FINANCIAL_PROFILE create or update APIs

Line 1657: -- Purpose: populates BOT for HZ_FINANCIAL_PROFILE create or update

1653: END pop_hz_financial_reports;
1654:
1655: -----------------------------------------------------------------
1656: -- Procedure name: pop_hz_financial_profile()
1657: -- Purpose: populates BOT for HZ_FINANCIAL_PROFILE create or update
1658: -- Scope: internal
1659: -- Called From: V2 API
1660: -- Called By: HZ_FINANCIAL_PROFILE create or update APIs
1661: -- Input Parameters:

Line 1660: -- Called By: HZ_FINANCIAL_PROFILE create or update APIs

1656: -- Procedure name: pop_hz_financial_profile()
1657: -- Purpose: populates BOT for HZ_FINANCIAL_PROFILE create or update
1658: -- Scope: internal
1659: -- Called From: V2 API
1660: -- Called By: HZ_FINANCIAL_PROFILE create or update APIs
1661: -- Input Parameters:
1662: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1663: -- p_financial_profile_id IN NUMBER
1664: --

Line 1666: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_PROFILE

1662: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1663: -- p_financial_profile_id IN NUMBER
1664: --
1665: -- Note:
1666: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_PROFILE
1667: -- This procedure must ensure that the combination is valid before populating BOT
1668: --
1669: -- PARENT BO: ORG :: CHILD BO:
1670: -- PARENT BO: PERSON :: CHILD BO:

Line 1672: PROCEDURE pop_hz_financial_profile(p_operation IN VARCHAR2, p_financial_profile_id IN NUMBER) IS

1668: --
1669: -- PARENT BO: ORG :: CHILD BO:
1670: -- PARENT BO: PERSON :: CHILD BO:
1671: -----------------------------------------------------------------
1672: PROCEDURE pop_hz_financial_profile(p_operation IN VARCHAR2, p_financial_profile_id IN NUMBER) IS
1673:
1674: -- cursor statement to select the info from child table
1675: CURSOR c_child IS
1676: SELECT fp.LAST_UPDATE_DATE lud, fp.PARTY_ID parent_id,

Line 1679: FROM HZ_FINANCIAL_PROFILE fp, HZ_PARTIES p

1675: CURSOR c_child IS
1676: SELECT fp.LAST_UPDATE_DATE lud, fp.PARTY_ID parent_id,
1677: fp.FINANCIAL_PROFILE_ID child_id,
1678: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
1679: FROM HZ_FINANCIAL_PROFILE fp, HZ_PARTIES p
1680: WHERE fp.FINANCIAL_PROFILE_ID = P_FINANCIAL_PROFILE_ID
1681: AND fp.party_id = p.party_id
1682: AND p.party_type in ('ORGANIZATION', 'PERSON');
1683:

Line 1685: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_profile';

1681: AND fp.party_id = p.party_id
1682: AND p.party_type in ('ORGANIZATION', 'PERSON');
1683:
1684: -- local variables
1685: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_profile';
1686: l_parent_id NUMBER; -- used to store parent entity identifier
1687: l_bo_code VARCHAR2(30); -- used to store BO Code
1688: l_child_id NUMBER; -- used to store HZ_FINANCIAL_PROFILE identifier
1689: l_lud DATE; -- used to store the child last update date

Line 1688: l_child_id NUMBER; -- used to store HZ_FINANCIAL_PROFILE identifier

1684: -- local variables
1685: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_profile';
1686: l_parent_id NUMBER; -- used to store parent entity identifier
1687: l_bo_code VARCHAR2(30); -- used to store BO Code
1688: l_child_id NUMBER; -- used to store HZ_FINANCIAL_PROFILE identifier
1689: l_lud DATE; -- used to store the child last update date
1690: l_child_rec_exists_no NUMBER;
1691: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_PROFILE';
1692: BEGIN

Line 1691: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_PROFILE';

1687: l_bo_code VARCHAR2(30); -- used to store BO Code
1688: l_child_id NUMBER; -- used to store HZ_FINANCIAL_PROFILE identifier
1689: l_lud DATE; -- used to store the child last update date
1690: l_child_rec_exists_no NUMBER;
1691: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_PROFILE';
1692: BEGIN
1693: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_profile+',
1694: p_prefix=>l_debug_prefix,
1695: p_msg_level=>fnd_log.level_procedure);

Line 1693: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_profile+',

1689: l_lud DATE; -- used to store the child last update date
1690: l_child_rec_exists_no NUMBER;
1691: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_PROFILE';
1692: BEGIN
1693: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_profile+',
1694: p_prefix=>l_debug_prefix,
1695: p_msg_level=>fnd_log.level_procedure);
1696:
1697: -- validate p_operation

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

1697: -- validate p_operation
1698: IF p_operation IN ('I','U') THEN
1699: NULL;
1700: ELSE
1701: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_profile',
1702: p_prefix=>l_debug_prefix,
1703: p_msg_level=>fnd_log.level_procedure);
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;

Line 1736: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_PROFILE', NULL,

1732: INSERT INTO HZ_BUS_OBJ_TRACKING
1733: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1734: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1735: ) VALUES (
1736: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_PROFILE', NULL,
1737: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
1738:
1739: -- populate org party record
1740: pop_parent_record(p_child_id => l_parent_id,

Line 1750: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_profile-',

1746: p_pbo_code => NULL);
1747: END ; -- anonymous block end
1748: END LOOP;
1749:
1750: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_profile-',
1751: p_prefix=>l_debug_prefix,
1752: p_msg_level=>fnd_log.level_procedure);
1753: EXCEPTION
1754: WHEN OTHERS THEN

Line 1759: END pop_hz_financial_profile;

1755: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1756: p_prefix=>l_debug_prefix,
1757: p_msg_level=>fnd_log.level_procedure);
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END pop_hz_financial_profile;
1760:
1761: -----------------------------------------------------------------
1762: -- Procedure name: pop_hz_financial_numbers()
1763: -- Purpose: populates BOT for HZ_FINANCIAL_NUMBERS create or update