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_ROLE_RESPONSIBILITY

Line 197: -- Procedure name: pop_hz_role_responsibility()

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
199: -- Scope: internal
200: -- Called From: V2 API
201: -- Called By: HZ_ROLE_RESPONSIBILITY create or update APIs

Line 198: -- Purpose: populates BOT for HZ_ROLE_RESPONSIBILITY create or update

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
199: -- Scope: internal
200: -- Called From: V2 API
201: -- Called By: HZ_ROLE_RESPONSIBILITY create or update APIs
202: -- Input Parameters:

Line 201: -- Called By: HZ_ROLE_RESPONSIBILITY create or update APIs

197: -- Procedure name: pop_hz_role_responsibility()
198: -- Purpose: populates BOT for HZ_ROLE_RESPONSIBILITY create or update
199: -- Scope: internal
200: -- Called From: V2 API
201: -- Called By: HZ_ROLE_RESPONSIBILITY create or update APIs
202: -- Input Parameters:
203: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
204: -- p_responsibility_id IN NUMBER
205: --

Line 207: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ROLE_RESPONSIBILITY

203: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
204: -- p_responsibility_id IN NUMBER
205: --
206: -- Note:
207: -- Following are the allowed PARENT and CHILD BO combinations for HZ_ROLE_RESPONSIBILITY
208: -- This procedure must ensure that the combination is valid before populating BOT
209: --
210: -- PARENT BO: CUST_ACCT_CONTACT :: CHILD BO:
211: -----------------------------------------------------------------

Line 212: PROCEDURE pop_hz_role_responsibility(p_operation IN VARCHAR2, p_responsibility_id IN NUMBER) IS

208: -- This procedure must ensure that the combination is valid before populating BOT
209: --
210: -- PARENT BO: CUST_ACCT_CONTACT :: CHILD BO:
211: -----------------------------------------------------------------
212: PROCEDURE pop_hz_role_responsibility(p_operation IN VARCHAR2, p_responsibility_id IN NUMBER) IS
213:
214: -- cursor statement to select the info from child table
215: CURSOR c_child IS
216: SELECT rr.LAST_UPDATE_DATE lud, rr.CUST_ACCOUNT_ROLE_ID parent_id, rr.RESPONSIBILITY_ID child_id,

Line 220: FROM HZ_ROLE_RESPONSIBILITY rr, HZ_CUST_ACCOUNT_ROLES car

216: SELECT rr.LAST_UPDATE_DATE lud, rr.CUST_ACCOUNT_ROLE_ID parent_id, rr.RESPONSIBILITY_ID child_id,
217: nvl(car.cust_acct_site_id, car.cust_account_id) car_parent_id,
218: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') car_parent_entity,
219: decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') car_parent_bo
220: FROM HZ_ROLE_RESPONSIBILITY rr, HZ_CUST_ACCOUNT_ROLES car
221: WHERE rr.RESPONSIBILITY_ID = P_RESPONSIBILITY_ID
222: AND rr.cust_account_role_id = car.cust_account_role_id
223: AND car.cust_account_id > 0;
224:

Line 226: l_debug_prefix VARCHAR2(40) := 'pop_hz_role_responsibility';

222: AND rr.cust_account_role_id = car.cust_account_role_id
223: AND car.cust_account_id > 0;
224:
225: -- local variables
226: l_debug_prefix VARCHAR2(40) := 'pop_hz_role_responsibility';
227: l_parent_id NUMBER; -- used to store parent entity identifier
228: l_child_id NUMBER; -- used to store HZ_ROLE_RESPONSIBILITY identifier
229: l_lud DATE; -- used to store the child last update date
230: l_child_rec_exists_no NUMBER;

Line 228: l_child_id NUMBER; -- used to store HZ_ROLE_RESPONSIBILITY identifier

224:
225: -- local variables
226: l_debug_prefix VARCHAR2(40) := 'pop_hz_role_responsibility';
227: l_parent_id NUMBER; -- used to store parent entity identifier
228: l_child_id NUMBER; -- used to store HZ_ROLE_RESPONSIBILITY identifier
229: l_lud DATE; -- used to store the child last update date
230: l_child_rec_exists_no NUMBER;
231: l_car_parent_id NUMBER; -- parent Id of cust account roles
232: l_car_parent_entity VARCHAR2(30); -- entity name of cust account roles parent

Line 234: l_cen VARCHAR2(30) := 'HZ_ROLE_RESPONSIBILITY';

230: l_child_rec_exists_no NUMBER;
231: l_car_parent_id NUMBER; -- parent Id of cust account roles
232: l_car_parent_entity VARCHAR2(30); -- entity name of cust account roles parent
233: l_car_parent_bo VARCHAR2(30); -- business object of cust account roles parent
234: l_cen VARCHAR2(30) := 'HZ_ROLE_RESPONSIBILITY';
235: BEGIN
236: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_role_responsibility+',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);

Line 236: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_role_responsibility+',

232: l_car_parent_entity VARCHAR2(30); -- entity name of cust account roles parent
233: l_car_parent_bo VARCHAR2(30); -- business object of cust account roles parent
234: l_cen VARCHAR2(30) := 'HZ_ROLE_RESPONSIBILITY';
235: BEGIN
236: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_role_responsibility+',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239:
240: -- validate p_operation

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

240: -- validate p_operation
241: IF p_operation IN ('I','U') THEN
242: NULL;
243: ELSE
244: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_role_responsibility',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;

Line 281: 'N', p_operation, l_child_id, 'HZ_ROLE_RESPONSIBILITY', NULL,

277: INSERT INTO HZ_BUS_OBJ_TRACKING
278: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
279: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
280: ) VALUES (
281: 'N', p_operation, l_child_id, 'HZ_ROLE_RESPONSIBILITY', NULL,
282: l_lud, l_lud, 'HZ_CUST_ACCOUNT_ROLES', l_parent_id, 'CUST_ACCT_CONTACT');
283:
284: -- if record not existing for customer account contact, insert into hz_bus_obj_tracking
285: pop_parent_record(p_child_id => l_parent_id,

Line 295: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_role_responsibility-',

291: p_pbo_code => l_car_parent_bo);
292: END ; -- anonymous block end
293: END LOOP;
294:
295: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_role_responsibility-',
296: p_prefix=>l_debug_prefix,
297: p_msg_level=>fnd_log.level_procedure);
298: EXCEPTION
299: WHEN OTHERS THEN

Line 304: END pop_hz_role_responsibility;

300: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
301: p_prefix=>l_debug_prefix,
302: p_msg_level=>fnd_log.level_procedure);
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END pop_hz_role_responsibility;
305:
306: -----------------------------------------------------------------
307: -- Procedure name: pop_hz_relationships()
308: -- Purpose: populates BOT for HZ_RELATIONSHIPS create or update