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_NUMBERS

Line 1762: -- Procedure name: pop_hz_financial_numbers()

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
1764: -- Scope: internal
1765: -- Called From: V2 API
1766: -- Called By: HZ_FINANCIAL_NUMBERS create or update APIs

Line 1763: -- Purpose: populates BOT for HZ_FINANCIAL_NUMBERS create or update

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
1764: -- Scope: internal
1765: -- Called From: V2 API
1766: -- Called By: HZ_FINANCIAL_NUMBERS create or update APIs
1767: -- Input Parameters:

Line 1766: -- Called By: HZ_FINANCIAL_NUMBERS create or update APIs

1762: -- Procedure name: pop_hz_financial_numbers()
1763: -- Purpose: populates BOT for HZ_FINANCIAL_NUMBERS create or update
1764: -- Scope: internal
1765: -- Called From: V2 API
1766: -- Called By: HZ_FINANCIAL_NUMBERS create or update APIs
1767: -- Input Parameters:
1768: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1769: -- p_financial_number_id IN NUMBER
1770: --

Line 1772: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_NUMBERS

1768: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1769: -- p_financial_number_id IN NUMBER
1770: --
1771: -- Note:
1772: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_NUMBERS
1773: -- This procedure must ensure that the combination is valid before populating BOT
1774: --
1775: -- PARENT BO: FIN_REPORT :: CHILD BO:
1776: -----------------------------------------------------------------

Line 1777: PROCEDURE pop_hz_financial_numbers(p_operation IN VARCHAR2, p_financial_number_id IN NUMBER) IS

1773: -- This procedure must ensure that the combination is valid before populating BOT
1774: --
1775: -- PARENT BO: FIN_REPORT :: CHILD BO:
1776: -----------------------------------------------------------------
1777: PROCEDURE pop_hz_financial_numbers(p_operation IN VARCHAR2, p_financial_number_id IN NUMBER) IS
1778:
1779: -- cursor statement to select the info from child table
1780: CURSOR C_child IS
1781: SELECT fn.LAST_UPDATE_DATE lud, fn.FINANCIAL_REPORT_ID parent_id,

Line 1783: FROM HZ_FINANCIAL_NUMBERS fn, HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p

1779: -- cursor statement to select the info from child table
1780: CURSOR C_child IS
1781: SELECT fn.LAST_UPDATE_DATE lud, fn.FINANCIAL_REPORT_ID parent_id,
1782: fn.FINANCIAL_NUMBER_ID child_id, fr.party_id party_id
1783: FROM HZ_FINANCIAL_NUMBERS fn, HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
1784: WHERE fn.FINANCIAL_NUMBER_ID = P_FINANCIAL_NUMBER_ID
1785: AND fn.financial_report_id = fr.financial_report_id
1786: AND fr.party_id = p.party_id
1787: AND p.party_type = 'ORGANIZATION';

Line 1790: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_numbers';

1786: AND fr.party_id = p.party_id
1787: AND p.party_type = 'ORGANIZATION';
1788:
1789: -- local variables
1790: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_numbers';
1791: l_parent_id NUMBER; -- used to store parent entity identifier
1792: l_child_id NUMBER; -- used to store HZ_FINANCIAL_NUMBERS identifier
1793: l_lud DATE; -- used to store the child last update date
1794: l_child_rec_exists_no NUMBER;

Line 1792: l_child_id NUMBER; -- used to store HZ_FINANCIAL_NUMBERS identifier

1788:
1789: -- local variables
1790: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_numbers';
1791: l_parent_id NUMBER; -- used to store parent entity identifier
1792: l_child_id NUMBER; -- used to store HZ_FINANCIAL_NUMBERS identifier
1793: l_lud DATE; -- used to store the child last update date
1794: l_child_rec_exists_no NUMBER;
1795: l_party_id NUMBER;
1796: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_NUMBERS';

Line 1796: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_NUMBERS';

1792: l_child_id NUMBER; -- used to store HZ_FINANCIAL_NUMBERS identifier
1793: l_lud DATE; -- used to store the child last update date
1794: l_child_rec_exists_no NUMBER;
1795: l_party_id NUMBER;
1796: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_NUMBERS';
1797: BEGIN
1798: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_numbers+',
1799: p_prefix=>l_debug_prefix,
1800: p_msg_level=>fnd_log.level_procedure);

Line 1798: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_numbers+',

1794: l_child_rec_exists_no NUMBER;
1795: l_party_id NUMBER;
1796: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_NUMBERS';
1797: BEGIN
1798: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_numbers+',
1799: p_prefix=>l_debug_prefix,
1800: p_msg_level=>fnd_log.level_procedure);
1801:
1802: -- validate p_operation

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

1802: -- validate p_operation
1803: IF p_operation IN ('I','U') THEN
1804: NULL;
1805: ELSE
1806: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_numbers',
1807: p_prefix=>l_debug_prefix,
1808: p_msg_level=>fnd_log.level_procedure);
1809: RAISE FND_API.G_EXC_ERROR;
1810: END IF;

Line 1841: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_NUMBERS', NULL,

1837: INSERT INTO HZ_BUS_OBJ_TRACKING
1838: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1839: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1840: ) VALUES (
1841: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_NUMBERS', NULL,
1842: l_lud, l_lud, 'HZ_FINANCIAL_REPORTS', l_parent_id, 'FIN_REPORT');
1843:
1844: -- populate org party record
1845: pop_parent_record(p_child_id => l_parent_id,

Line 1864: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_numbers-',

1860: p_pbo_code => NULL);
1861: END ; -- anonymous block end
1862: END LOOP;
1863:
1864: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_numbers-',
1865: p_prefix=>l_debug_prefix,
1866: p_msg_level=>fnd_log.level_procedure);
1867: EXCEPTION
1868: WHEN OTHERS THEN

Line 1873: END pop_hz_financial_numbers;

1869: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1870: p_prefix=>l_debug_prefix,
1871: p_msg_level=>fnd_log.level_procedure);
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: END pop_hz_financial_numbers;
1874:
1875: -----------------------------------------------------------------
1876: -- Procedure name: pop_hz_employment_history()
1877: -- Purpose: populates BOT for HZ_EMPLOYMENT_HISTORY create or update