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_REPORTS

Line 1542: -- Procedure name: pop_hz_financial_reports()

1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END pop_hz_locations;
1540:
1541: -----------------------------------------------------------------
1542: -- Procedure name: pop_hz_financial_reports()
1543: -- Purpose: populates BOT for HZ_FINANCIAL_REPORTS create or update
1544: -- Scope: internal
1545: -- Called From: V2 API
1546: -- Called By: HZ_FINANCIAL_REPORTS create or update APIs

Line 1543: -- Purpose: populates BOT for HZ_FINANCIAL_REPORTS create or update

1539: END pop_hz_locations;
1540:
1541: -----------------------------------------------------------------
1542: -- Procedure name: pop_hz_financial_reports()
1543: -- Purpose: populates BOT for HZ_FINANCIAL_REPORTS create or update
1544: -- Scope: internal
1545: -- Called From: V2 API
1546: -- Called By: HZ_FINANCIAL_REPORTS create or update APIs
1547: -- Input Parameters:

Line 1546: -- Called By: HZ_FINANCIAL_REPORTS create or update APIs

1542: -- Procedure name: pop_hz_financial_reports()
1543: -- Purpose: populates BOT for HZ_FINANCIAL_REPORTS create or update
1544: -- Scope: internal
1545: -- Called From: V2 API
1546: -- Called By: HZ_FINANCIAL_REPORTS create or update APIs
1547: -- Input Parameters:
1548: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1549: -- p_financial_report_id IN NUMBER
1550: --

Line 1552: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_REPORTS

1548: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1549: -- p_financial_report_id IN NUMBER
1550: --
1551: -- Note:
1552: -- Following are the allowed PARENT and CHILD BO combinations for HZ_FINANCIAL_REPORTS
1553: -- This procedure must ensure that the combination is valid before populating BOT
1554: --
1555: -- PARENT BO: ORG :: CHILD BO: FIN_REPORT
1556: -----------------------------------------------------------------

Line 1557: PROCEDURE pop_hz_financial_reports(p_operation IN VARCHAR2, p_financial_report_id IN NUMBER) IS

1553: -- This procedure must ensure that the combination is valid before populating BOT
1554: --
1555: -- PARENT BO: ORG :: CHILD BO: FIN_REPORT
1556: -----------------------------------------------------------------
1557: PROCEDURE pop_hz_financial_reports(p_operation IN VARCHAR2, p_financial_report_id IN NUMBER) IS
1558:
1559: -- cursor statement to select the info from child table
1560: CURSOR C_child IS
1561: SELECT fr.LAST_UPDATE_DATE lud, fr.PARTY_ID parent_id, fr.FINANCIAL_REPORT_ID child_id,

Line 1563: FROM HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p

1559: -- cursor statement to select the info from child table
1560: CURSOR C_child IS
1561: SELECT fr.LAST_UPDATE_DATE lud, fr.PARTY_ID parent_id, fr.FINANCIAL_REPORT_ID child_id,
1562: decode(p.party_type, 'ORGANIZATION', 'ORG', null) bo_code
1563: FROM HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
1564: WHERE fr.FINANCIAL_REPORT_ID = P_FINANCIAL_REPORT_ID
1565: AND fr.party_id = p.party_id
1566: AND p.party_type = 'ORGANIZATION';
1567:

Line 1569: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_reports';

1565: AND fr.party_id = p.party_id
1566: AND p.party_type = 'ORGANIZATION';
1567:
1568: -- local variables
1569: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_reports';
1570: l_parent_id NUMBER; -- used to store parent entity identifier
1571: l_bo_code VARCHAR2(30); -- used to store BO Code
1572: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
1573: l_child_id NUMBER; -- used to store HZ_FINANCIAL_REPORTS identifier

Line 1573: l_child_id NUMBER; -- used to store HZ_FINANCIAL_REPORTS identifier

1569: l_debug_prefix VARCHAR2(40) := 'pop_hz_financial_reports';
1570: l_parent_id NUMBER; -- used to store parent entity identifier
1571: l_bo_code VARCHAR2(30); -- used to store BO Code
1572: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
1573: l_child_id NUMBER; -- used to store HZ_FINANCIAL_REPORTS identifier
1574: l_lud DATE; -- used to store the child last update date
1575: l_child_rec_exists_no NUMBER;
1576: l_pop_flag VARCHAR2(1);
1577: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_REPORTS';

Line 1577: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_REPORTS';

1573: l_child_id NUMBER; -- used to store HZ_FINANCIAL_REPORTS identifier
1574: l_lud DATE; -- used to store the child last update date
1575: l_child_rec_exists_no NUMBER;
1576: l_pop_flag VARCHAR2(1);
1577: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_REPORTS';
1578: BEGIN
1579: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_reports+',
1580: p_prefix=>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_procedure);

Line 1579: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_reports+',

1575: l_child_rec_exists_no NUMBER;
1576: l_pop_flag VARCHAR2(1);
1577: l_cen VARCHAR2(30) := 'HZ_FINANCIAL_REPORTS';
1578: BEGIN
1579: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_reports+',
1580: p_prefix=>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_procedure);
1582:
1583: -- validate p_operation

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

1583: -- validate p_operation
1584: IF p_operation IN ('I','U') THEN
1585: NULL;
1586: ELSE
1587: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_reports',
1588: p_prefix=>l_debug_prefix,
1589: p_msg_level=>fnd_log.level_procedure);
1590: RAISE FND_API.G_EXC_ERROR;
1591: END IF;

Line 1630: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_REPORTS', 'FIN_REPORT',

1626: INSERT INTO HZ_BUS_OBJ_TRACKING
1627: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1628: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1629: ) VALUES (
1630: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_REPORTS', 'FIN_REPORT',
1631: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
1632:
1633: -- populate org party record
1634: pop_parent_record(p_child_id => l_parent_id,

Line 1644: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_reports-',

1640: p_pbo_code => NULL);
1641: END ; -- anonymous block end
1642: END LOOP;
1643:
1644: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_financial_reports-',
1645: p_prefix=>l_debug_prefix,
1646: p_msg_level=>fnd_log.level_procedure);
1647: EXCEPTION
1648: WHEN OTHERS THEN

Line 1653: END pop_hz_financial_reports;

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

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 1842: l_lud, l_lud, 'HZ_FINANCIAL_REPORTS', l_parent_id, 'FIN_REPORT');

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

Line 1847: p_centity_name => 'HZ_FINANCIAL_REPORTS',

1843:
1844: -- populate org party record
1845: pop_parent_record(p_child_id => l_parent_id,
1846: p_lud => l_lud,
1847: p_centity_name => 'HZ_FINANCIAL_REPORTS',
1848: p_cbo_code => 'FIN_REPORT',
1849: p_parent_id => l_party_id,
1850: p_pentity_name => 'HZ_PARTIES',
1851: p_pbo_code => 'ORG');