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_WORK_CLASS

Line 82: -- Procedure name: pop_hz_work_class()

78: NULL;
79: END pop_parent_record;
80:
81: -----------------------------------------------------------------
82: -- Procedure name: pop_hz_work_class()
83: -- Purpose: populates BOT for HZ_WORK_CLASS create or update
84: -- Scope: internal
85: -- Called From: V2 API
86: -- Called By: HZ_WORK_CLASS create or update APIs

Line 83: -- Purpose: populates BOT for HZ_WORK_CLASS create or update

79: END pop_parent_record;
80:
81: -----------------------------------------------------------------
82: -- Procedure name: pop_hz_work_class()
83: -- Purpose: populates BOT for HZ_WORK_CLASS create or update
84: -- Scope: internal
85: -- Called From: V2 API
86: -- Called By: HZ_WORK_CLASS create or update APIs
87: -- Input Parameters:

Line 86: -- Called By: HZ_WORK_CLASS create or update APIs

82: -- Procedure name: pop_hz_work_class()
83: -- Purpose: populates BOT for HZ_WORK_CLASS create or update
84: -- Scope: internal
85: -- Called From: V2 API
86: -- Called By: HZ_WORK_CLASS create or update APIs
87: -- Input Parameters:
88: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
89: -- p_work_class_id IN NUMBER
90: --

Line 92: -- Following are the allowed PARENT and CHILD BO combinations for HZ_WORK_CLASS

88: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
89: -- p_work_class_id IN NUMBER
90: --
91: -- Note:
92: -- Following are the allowed PARENT and CHILD BO combinations for HZ_WORK_CLASS
93: -- This procedure must ensure that the combination is valid before populating BOT
94: -- PARENT BO: EMP_HIST :: CHILD BO:
95: -----------------------------------------------------------------
96: PROCEDURE pop_hz_work_class(p_operation IN VARCHAR2, p_work_class_id IN NUMBER) IS

Line 96: PROCEDURE pop_hz_work_class(p_operation IN VARCHAR2, p_work_class_id IN NUMBER) IS

92: -- Following are the allowed PARENT and CHILD BO combinations for HZ_WORK_CLASS
93: -- This procedure must ensure that the combination is valid before populating BOT
94: -- PARENT BO: EMP_HIST :: CHILD BO:
95: -----------------------------------------------------------------
96: PROCEDURE pop_hz_work_class(p_operation IN VARCHAR2, p_work_class_id IN NUMBER) IS
97:
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,

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 109: l_debug_prefix VARCHAR2(40) := 'pop_hz_work_class';

105: AND eh.party_id = p.party_id
106: AND p.party_type = 'PERSON';
107:
108: -- local variables
109: l_debug_prefix VARCHAR2(40) := 'pop_hz_work_class';
110: l_parent_id NUMBER; -- used to store parent entity identifier
111: l_bo_code VARCHAR2(30); -- used to store BO Code
112: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
113: l_child_id NUMBER; -- used to store HZ_WORK_CLASS identifier

Line 113: l_child_id NUMBER; -- used to store HZ_WORK_CLASS identifier

109: l_debug_prefix VARCHAR2(40) := 'pop_hz_work_class';
110: l_parent_id NUMBER; -- used to store parent entity identifier
111: l_bo_code VARCHAR2(30); -- used to store BO Code
112: l_child_bo_code VARCHAR2(30); -- used to store Child BO Code (if child entity is a root node)
113: l_child_id NUMBER; -- used to store HZ_WORK_CLASS identifier
114: l_lud DATE; -- used to store the child last update date
115: l_child_rec_exists_no NUMBER;
116: l_party_id NUMBER; -- person party_id of employment history record
117: l_cen VARCHAR2(30) := 'HZ_WORK_CLASS';

Line 117: l_cen VARCHAR2(30) := 'HZ_WORK_CLASS';

113: l_child_id NUMBER; -- used to store HZ_WORK_CLASS identifier
114: l_lud DATE; -- used to store the child last update date
115: l_child_rec_exists_no NUMBER;
116: l_party_id NUMBER; -- person party_id of employment history record
117: l_cen VARCHAR2(30) := 'HZ_WORK_CLASS';
118: BEGIN
119: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_work_class+',
120: p_prefix=>l_debug_prefix,
121: p_msg_level=>fnd_log.level_procedure);

Line 119: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_work_class+',

115: l_child_rec_exists_no NUMBER;
116: l_party_id NUMBER; -- person party_id of employment history record
117: l_cen VARCHAR2(30) := 'HZ_WORK_CLASS';
118: BEGIN
119: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_work_class+',
120: p_prefix=>l_debug_prefix,
121: p_msg_level=>fnd_log.level_procedure);
122:
123: -- validate p_operation

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

123: -- validate p_operation
124: IF p_operation IN ('I','U') THEN
125: NULL;
126: ELSE
127: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_work_class',
128: p_prefix=>l_debug_prefix,
129: p_msg_level=>fnd_log.level_procedure);
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;

Line 162: 'N', p_operation, l_child_id, 'HZ_WORK_CLASS', NULL,

158: INSERT INTO HZ_BUS_OBJ_TRACKING
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,

Line 185: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_work_class-',

181: p_pbo_code => NULL);
182: END; -- anonymous block end
183: END LOOP;
184:
185: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_work_class-',
186: p_prefix=>l_debug_prefix,
187: p_msg_level=>fnd_log.level_procedure);
188: EXCEPTION
189: WHEN OTHERS THEN

Line 194: END pop_hz_work_class;

190: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
191: p_prefix=>l_debug_prefix,
192: p_msg_level=>fnd_log.level_procedure);
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END pop_hz_work_class;
195:
196: -----------------------------------------------------------------
197: -- Procedure name: pop_hz_role_responsibility()
198: -- Purpose: populates BOT for HZ_ROLE_RESPONSIBILITY create or update