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_EDUCATION

Line 1987: -- Procedure name: pop_hz_education()

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
1989: -- Scope: internal
1990: -- Called From: V2 API
1991: -- Called By: HZ_EDUCATION create or update APIs

Line 1988: -- Purpose: populates BOT for HZ_EDUCATION create or update

1984: END pop_hz_employment_history;
1985:
1986: -----------------------------------------------------------------
1987: -- Procedure name: pop_hz_education()
1988: -- Purpose: populates BOT for HZ_EDUCATION create or update
1989: -- Scope: internal
1990: -- Called From: V2 API
1991: -- Called By: HZ_EDUCATION create or update APIs
1992: -- Input Parameters:

Line 1991: -- Called By: HZ_EDUCATION create or update APIs

1987: -- Procedure name: pop_hz_education()
1988: -- Purpose: populates BOT for HZ_EDUCATION create or update
1989: -- Scope: internal
1990: -- Called From: V2 API
1991: -- Called By: HZ_EDUCATION create or update APIs
1992: -- Input Parameters:
1993: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1994: -- p_education_id IN NUMBER
1995: --

Line 1997: -- Following are the allowed PARENT and CHILD BO combinations for HZ_EDUCATION

1993: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
1994: -- p_education_id IN NUMBER
1995: --
1996: -- Note:
1997: -- Following are the allowed PARENT and CHILD BO combinations for HZ_EDUCATION
1998: -- This procedure must ensure that the combination is valid before populating BOT
1999: --
2000: -- PARENT BO: PERSON :: CHILD BO:
2001: -----------------------------------------------------------------

Line 2002: PROCEDURE pop_hz_education(p_operation IN VARCHAR2, p_EDUCATION_ID IN NUMBER) IS

1998: -- This procedure must ensure that the combination is valid before populating BOT
1999: --
2000: -- PARENT BO: PERSON :: CHILD BO:
2001: -----------------------------------------------------------------
2002: PROCEDURE pop_hz_education(p_operation IN VARCHAR2, p_EDUCATION_ID IN NUMBER) IS
2003:
2004: -- cursor statement to select the info from child table
2005: CURSOR C_child IS
2006: SELECT edu.LAST_UPDATE_DATE lud, edu.PARTY_ID parent_id, edu.EDUCATION_ID child_id

Line 2007: FROM HZ_EDUCATION edu, HZ_PARTIES p

2003:
2004: -- cursor statement to select the info from child table
2005: CURSOR C_child IS
2006: SELECT edu.LAST_UPDATE_DATE lud, edu.PARTY_ID parent_id, edu.EDUCATION_ID child_id
2007: FROM HZ_EDUCATION edu, HZ_PARTIES p
2008: WHERE edu.EDUCATION_ID = P_EDUCATION_ID
2009: AND edu.party_id = p.party_id
2010: AND p.party_type = 'PERSON';
2011:

Line 2013: l_debug_prefix VARCHAR2(40) := 'pop_hz_education';

2009: AND edu.party_id = p.party_id
2010: AND p.party_type = 'PERSON';
2011:
2012: -- local variables
2013: l_debug_prefix VARCHAR2(40) := 'pop_hz_education';
2014: l_parent_id NUMBER; -- used to store parent entity identifier
2015: l_child_id NUMBER; -- used to store HZ_EDUCATION identifier
2016: l_lud DATE; -- used to store the child last update date
2017: l_child_rec_exists_no NUMBER;

Line 2015: l_child_id NUMBER; -- used to store HZ_EDUCATION identifier

2011:
2012: -- local variables
2013: l_debug_prefix VARCHAR2(40) := 'pop_hz_education';
2014: l_parent_id NUMBER; -- used to store parent entity identifier
2015: l_child_id NUMBER; -- used to store HZ_EDUCATION identifier
2016: l_lud DATE; -- used to store the child last update date
2017: l_child_rec_exists_no NUMBER;
2018: l_cen VARCHAR2(30) := 'HZ_EDUCATION';
2019: BEGIN

Line 2018: l_cen VARCHAR2(30) := 'HZ_EDUCATION';

2014: l_parent_id NUMBER; -- used to store parent entity identifier
2015: l_child_id NUMBER; -- used to store HZ_EDUCATION identifier
2016: l_lud DATE; -- used to store the child last update date
2017: l_child_rec_exists_no NUMBER;
2018: l_cen VARCHAR2(30) := 'HZ_EDUCATION';
2019: BEGIN
2020: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_education+',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);

Line 2020: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_education+',

2016: l_lud DATE; -- used to store the child last update date
2017: l_child_rec_exists_no NUMBER;
2018: l_cen VARCHAR2(30) := 'HZ_EDUCATION';
2019: BEGIN
2020: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_education+',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023:
2024: -- validate p_operation

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

2024: -- validate p_operation
2025: IF p_operation IN ('I','U') THEN
2026: NULL;
2027: ELSE
2028: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_education',
2029: p_prefix=>l_debug_prefix,
2030: p_msg_level=>fnd_log.level_procedure);
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;

Line 2062: 'N', p_operation, l_child_id, 'HZ_EDUCATION', NULL,

2058: INSERT INTO HZ_BUS_OBJ_TRACKING
2059: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2060: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2061: ) VALUES (
2062: 'N', p_operation, l_child_id, 'HZ_EDUCATION', NULL,
2063: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
2064:
2065: -- populate org party record
2066: pop_parent_record(p_child_id => l_parent_id,

Line 2076: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_education-',

2072: p_pbo_code => NULL);
2073: END ; -- anonymous block end
2074: END LOOP;
2075:
2076: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_education-',
2077: p_prefix=>l_debug_prefix,
2078: p_msg_level=>fnd_log.level_procedure);
2079: EXCEPTION
2080: WHEN OTHERS THEN

Line 2085: END pop_hz_education;

2081: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END pop_hz_education;
2086:
2087: -----------------------------------------------------------------
2088: -- Procedure name: pop_hz_cust_site_uses_all()
2089: -- Purpose: populates BOT for HZ_CUST_SITE_USES_ALL create or update