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_EMPLOYMENT_HISTORY

Line 102: FROM HZ_WORK_CLASS wc, HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p

98: -- cursor statement to select the info from child table
99: CURSOR c_child IS
100: SELECT wc.LAST_UPDATE_DATE lud, wc.EMPLOYMENT_HISTORY_ID parent_id, eh.party_id party_id,
101: wc.WORK_CLASS_ID child_id
102: FROM HZ_WORK_CLASS wc, HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
103: WHERE wc.WORK_CLASS_ID = P_WORK_CLASS_ID
104: AND wc.employment_history_id = eh.employment_history_id
105: AND eh.party_id = p.party_id
106: AND p.party_type = 'PERSON';

Line 163: l_lud, l_lud, 'HZ_EMPLOYMENT_HISTORY', l_parent_id, 'EMP_HIST');

159: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
160: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
161: ) VALUES (
162: 'N', p_operation, l_child_id, 'HZ_WORK_CLASS', NULL,
163: l_lud, l_lud, 'HZ_EMPLOYMENT_HISTORY', l_parent_id, 'EMP_HIST');
164:
165: -- if record not existing for employment history, insert into hz_bus_obj_tracking
166: pop_parent_record(p_child_id => l_parent_id,
167: p_lud => l_lud,

Line 168: p_centity_name => 'HZ_EMPLOYMENT_HISTORY',

164:
165: -- if record not existing for employment history, insert into hz_bus_obj_tracking
166: pop_parent_record(p_child_id => l_parent_id,
167: p_lud => l_lud,
168: p_centity_name => 'HZ_EMPLOYMENT_HISTORY',
169: p_cbo_code => 'EMP_HIST',
170: p_parent_id => l_party_id,
171: p_pentity_name => 'HZ_PARTIES',
172: p_pbo_code => 'PERSON');

Line 1876: -- Procedure name: pop_hz_employment_history()

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
1878: -- Scope: internal
1879: -- Called From: V2 API
1880: -- Called By: HZ_EMPLOYMENT_HISTORY create or update APIs

Line 1877: -- Purpose: populates BOT for HZ_EMPLOYMENT_HISTORY create or update

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
1878: -- Scope: internal
1879: -- Called From: V2 API
1880: -- Called By: HZ_EMPLOYMENT_HISTORY create or update APIs
1881: -- Input Parameters:

Line 1880: -- Called By: HZ_EMPLOYMENT_HISTORY create or update APIs

1876: -- Procedure name: pop_hz_employment_history()
1877: -- Purpose: populates BOT for HZ_EMPLOYMENT_HISTORY create or update
1878: -- Scope: internal
1879: -- Called From: V2 API
1880: -- Called By: HZ_EMPLOYMENT_HISTORY create or update APIs
1881: -- Input Parameters:
1882: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1883: -- p_employment_history_id IN NUMBER
1884: --

Line 1886: -- Following are the allowed PARENT and CHILD BO combinations for HZ_EMPLOYMENT_HISTORY

1882: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1883: -- p_employment_history_id IN NUMBER
1884: --
1885: -- Note:
1886: -- Following are the allowed PARENT and CHILD BO combinations for HZ_EMPLOYMENT_HISTORY
1887: -- This procedure must ensure that the combination is valid before populating BOT
1888: --
1889: -- PARENT BO: PERSON :: CHILD BO: EMP_HIST
1890: -----------------------------------------------------------------

Line 1891: PROCEDURE pop_hz_employment_history(p_operation IN VARCHAR2, p_EMPLOYMENT_HISTORY_ID IN NUMBER) IS

1887: -- This procedure must ensure that the combination is valid before populating BOT
1888: --
1889: -- PARENT BO: PERSON :: CHILD BO: EMP_HIST
1890: -----------------------------------------------------------------
1891: PROCEDURE pop_hz_employment_history(p_operation IN VARCHAR2, p_EMPLOYMENT_HISTORY_ID IN NUMBER) IS
1892:
1893: -- cursor statement to select the info from child table
1894: CURSOR C_child IS
1895: SELECT eh.LAST_UPDATE_DATE lud, eh.PARTY_ID parent_id,

Line 1897: FROM HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p

1893: -- cursor statement to select the info from child table
1894: CURSOR C_child IS
1895: SELECT eh.LAST_UPDATE_DATE lud, eh.PARTY_ID parent_id,
1896: eh.EMPLOYMENT_HISTORY_ID child_id
1897: FROM HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
1898: WHERE eh.EMPLOYMENT_HISTORY_ID = P_EMPLOYMENT_HISTORY_ID
1899: AND eh.party_id = p.party_id
1900: AND p.party_type = 'PERSON';
1901:

Line 1903: l_debug_prefix VARCHAR2(40) := 'pop_hz_employment_history';

1899: AND eh.party_id = p.party_id
1900: AND p.party_type = 'PERSON';
1901:
1902: -- local variables
1903: l_debug_prefix VARCHAR2(40) := 'pop_hz_employment_history';
1904: l_parent_id NUMBER; -- used to store parent entity identifier
1905: l_child_id NUMBER; -- used to store HZ_EMPLOYMENT_HISTORY identifier
1906: l_lud DATE; -- used to store the child last update date
1907: l_child_rec_exists_no NUMBER;

Line 1905: l_child_id NUMBER; -- used to store HZ_EMPLOYMENT_HISTORY identifier

1901:
1902: -- local variables
1903: l_debug_prefix VARCHAR2(40) := 'pop_hz_employment_history';
1904: l_parent_id NUMBER; -- used to store parent entity identifier
1905: l_child_id NUMBER; -- used to store HZ_EMPLOYMENT_HISTORY identifier
1906: l_lud DATE; -- used to store the child last update date
1907: l_child_rec_exists_no NUMBER;
1908: l_pop_flag VARCHAR2(1);
1909: l_cen VARCHAR2(30) := 'HZ_EMPLOYMENT_HISTORY';

Line 1909: l_cen VARCHAR2(30) := 'HZ_EMPLOYMENT_HISTORY';

1905: l_child_id NUMBER; -- used to store HZ_EMPLOYMENT_HISTORY identifier
1906: l_lud DATE; -- used to store the child last update date
1907: l_child_rec_exists_no NUMBER;
1908: l_pop_flag VARCHAR2(1);
1909: l_cen VARCHAR2(30) := 'HZ_EMPLOYMENT_HISTORY';
1910: BEGIN
1911: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_employment_history+',
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_procedure);

Line 1911: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_employment_history+',

1907: l_child_rec_exists_no NUMBER;
1908: l_pop_flag VARCHAR2(1);
1909: l_cen VARCHAR2(30) := 'HZ_EMPLOYMENT_HISTORY';
1910: BEGIN
1911: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_employment_history+',
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_procedure);
1914:
1915: -- validate p_operation

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

1915: -- validate p_operation
1916: IF p_operation IN ('I','U') THEN
1917: NULL;
1918: ELSE
1919: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_employment_history',
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;

Line 1937: AND CHILD_ENTITY_NAME = 'HZ_EMPLOYMENT_HISTORY'

1933: l_child_rec_exists_no := 0;
1934: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1935: FROM HZ_BUS_OBJ_TRACKING
1936: WHERE event_id IS NULL
1937: AND CHILD_ENTITY_NAME = 'HZ_EMPLOYMENT_HISTORY'
1938: AND CHILD_ID = l_child_id
1939: AND rownum = 1;
1940:
1941: IF l_child_rec_exists_no <> 0 THEN

Line 1961: 'N', p_operation, l_child_id, 'HZ_EMPLOYMENT_HISTORY', 'EMP_HIST',

1957: INSERT INTO HZ_BUS_OBJ_TRACKING
1958: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1959: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1960: ) VALUES (
1961: 'N', p_operation, l_child_id, 'HZ_EMPLOYMENT_HISTORY', 'EMP_HIST',
1962: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
1963:
1964: -- populate org party record
1965: pop_parent_record(p_child_id => l_parent_id,

Line 1975: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_employment_history-',

1971: p_pbo_code => NULL);
1972: END ; -- anonymous block end
1973: END LOOP;
1974:
1975: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_employment_history-',
1976: p_prefix=>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_procedure);
1978: EXCEPTION
1979: WHEN OTHERS THEN

Line 1984: END pop_hz_employment_history;

1980: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: END pop_hz_employment_history;
1985:
1986: -----------------------------------------------------------------
1987: -- Procedure name: pop_hz_education()
1988: -- Purpose: populates BOT for HZ_EDUCATION create or update