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_BES_BO_RAISE_PKG dependencies on HZ_BUS_OBJ_TRACKING

Line 379: FROM hz_bus_obj_tracking

375: CURSOR c_bot_log ( cp_evtid NUMBER, cp_bo_code VARCHAR2) IS
376: SELECT event_id CDH_EVENT_ID,
377: child_id CDH_OBJECT_ID,
378: parent_event_flag event_type
379: FROM hz_bus_obj_tracking
380: WHERE event_id = cp_evtid
381: AND CHILD_BO_CODE = cp_bo_code
382: AND parent_BO_CODE IS NULL
383: ORDER BY 2 desc;

Line 528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;

524:
525: IF G_BLK_EVT_RAISE = 'Y' THEN
526: LOG('get event id sequences for bulk event raising');
527: -- select the sequence a.k.a event ids needed
528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;
529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;

Line 529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;

525: IF G_BLK_EVT_RAISE = 'Y' THEN
526: LOG('get event id sequences for bulk event raising');
527: -- select the sequence a.k.a event ids needed
528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;
529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;

Line 530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;

526: LOG('get event id sequences for bulk event raising');
527: -- select the sequence a.k.a event ids needed
528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;
529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;

Line 531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;

527: -- select the sequence a.k.a event ids needed
528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;
529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;
535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;

Line 532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;

528: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_c_evtid FROM dual;
529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;
535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;
536: END IF;

Line 533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;

529: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgbo_u_evtid FROM dual;
530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;
535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;
536: END IF;
537:

Line 534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;

530: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_c_evtid FROM dual;
531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;
535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;
536: END IF;
537:
538: /*

Line 535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;

531: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_perbo_u_evtid FROM dual;
532: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_c_evtid FROM dual;
533: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_percustbo_u_evtid FROM dual;
534: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_c_evtid FROM dual;
535: SELECT hz_bus_obj_tracking_s.NEXTVAL INTO l_orgcustbo_u_evtid FROM dual;
536: END IF;
537:
538: /*
539: . select all the root nodes from the BOT for a give BO.

Line 564: END , hz_bus_obj_tracking_s.NEXTVAL),

560: DECODE (r.event_type_flag, 'U', l_orgcustbo_u_evtid, l_orgcustbo_c_evtid)
561: WHEN G_PER_CUST_BO_CODE THEN
562: DECODE (r.event_type_flag, 'U', l_percustbo_u_evtid, l_percustbo_c_evtid)
563: ELSE NULL
564: END , hz_bus_obj_tracking_s.NEXTVAL),
565: r.party_id, r.bo_code, r.event_type_flag
566: FROM (
567: SELECT
568: child_id PARTY_ID, child_bo_code BO_CODE,

Line 580: FROM hz_bus_obj_tracking t, hz_parties p

576: WHEN G_PER_CUST_BO_CODE THEN
577: DECODE(p.PERSON_CUST_BO_VERSION,G_PER_CUST_BO_VER,'U',NULL)
578: ELSE NULL
579: END event_type_flag
580: FROM hz_bus_obj_tracking t, hz_parties p
581: WHERE
582: t.child_bo_code IN
583: (G_PER_BO_CODE, G_ORG_BO_CODE, G_ORG_CUST_BO_CODE, G_PER_CUST_BO_CODE)
584: AND p.party_id = t.child_id

Line 711: INTO hz_bus_obj_tracking -- inserting person/org cust bo rec in BOT

707: -- from hz_parties table.
708: LOG('insert (in GT) all those related PERSON/ORG CUST BO records that are not in GT');
709: INSERT ALL
710: WHEN (child_bo_code is null) THEN
711: INTO hz_bus_obj_tracking -- inserting person/org cust bo rec in BOT
712: (CHILD_ENTITY_NAME, CHILD_ID, CHILD_OPERATION_FLAG, POPULATED_FLAG,
713: LAST_UPDATE_DATE, CHILD_BO_CODE, CREATION_DATE)
714: VALUES (
715: 'HZ_PARTIES', party_id, 'U', 'Y',

Line 717: INTO hz_bus_obj_tracking -- inserting person/org bo rec as child of person/org cust bo in BOT

713: LAST_UPDATE_DATE, CHILD_BO_CODE, CREATION_DATE)
714: VALUES (
715: 'HZ_PARTIES', party_id, 'U', 'Y',
716: l_cc_start_time, BO_CODE, l_cc_start_time)
717: INTO hz_bus_obj_tracking -- inserting person/org bo rec as child of person/org cust bo in BOT
718: (CHILD_ENTITY_NAME, CHILD_ID, CHILD_OPERATION_FLAG, POPULATED_FLAG,
719: LAST_UPDATE_DATE, CHILD_BO_CODE, CREATION_DATE,
720: PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE, child_event_id)
721: VALUES (

Line 735: END , hz_bus_obj_tracking_s.NEXTVAL), party_id, bo_code, event_type_flag)

731: DECODE (event_type_flag, 'U', l_orgcustbo_u_evtid, l_orgcustbo_c_evtid)
732: WHEN G_PER_CUST_BO_CODE THEN
733: DECODE (event_type_flag, 'U', l_percustbo_u_evtid, l_percustbo_c_evtid)
734: ELSE NULL
735: END , hz_bus_obj_tracking_s.NEXTVAL), party_id, bo_code, event_type_flag)
736: SELECT r.party_id, r.bo_code, r.c_bo_code,
737: CASE bo_code
738: WHEN G_ORG_CUST_BO_CODE THEN
739: DECODE(p.ORG_CUST_BO_VERSION,G_ORG_CUST_BO_VER,'U',NULL)

Line 761: ) r, hz_parties p, HZ_BUS_OBJ_TRACKING bot

757: WHERE t2.party_id = t1.party_id
758: AND t2.bo_code IN ('PERSON_CUST','ORG_CUST'))
759: AND EXISTS
760: ( SELECT 1 FROM hz_cust_accounts WHERE party_id = t1.party_id)
761: ) r, hz_parties p, HZ_BUS_OBJ_TRACKING bot
762: where
763: p.party_id = r.party_id
764: and bot.event_id(+) IS NULL
765: AND bot.CHILD_ENTITY_NAME (+) = 'HZ_PARTIES'