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_PARTIES

Line 309: . Write the BO version of BO (taken from BOD) to hz_parties table for all

305: . Update the Person as child record child_event_id with org_child_evt_id
306: . commit; -- As event raising already took place, we need to comminucate to
307: V2 APIs that they must start writing fresh entity records in BOT.
308: This can be acheived with this commit.
309: . Write the BO version of BO (taken from BOD) to hz_parties table for all
310: parties that were in GT table.
311: . Delete the records that were not part of any event from BOT.
312: This is based on creation_date being less that than the start time of the conc program.
313:

Line 319: on hz_parties table.

315: Two kinds of the root nodes (parties) that must be evaluated for
316: completness check and eventtype().
317: 1. First timers: Party records that are processed for the first time.
318: In other words, those party records for which BO_VERSION_NUMBER is null
319: on hz_parties table.
320: 2. Second timers: Party records that were processed earlier; but the
321: business object definition changed after that.
322: In other words, those party records for which BO_VERSION_NUMBER is different
323: from the current Business Object definition in the BOD table.

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 586: AND t.child_entity_name = 'HZ_PARTIES'

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
585: AND parent_bo_code IS NULL
586: AND t.child_entity_name = 'HZ_PARTIES'
587: AND t.event_id IS NULL) r;
588: COMMIT;
589: /*
590: -- debug code start

Line 707: -- from hz_parties table.

703: -- 2. Account record exists for the party.
704: -- This will also inser Org/Person Cust Records in GT
705: -- While populating the records in GT, this SQL will figure out the
706: -- short circuting for based on the Bo version numbers for cust business object
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

Line 715: 'HZ_PARTIES', party_id, 'U', 'Y',

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',
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,

Line 722: 'HZ_PARTIES', party_id, 'U', 'Y',

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 (
722: 'HZ_PARTIES', party_id, 'U', 'Y',
723: l_cc_start_time, C_BO_CODE, l_cc_start_time,
724: 'HZ_PARTIES', party_id, BO_CODE, party_id)
725: WHEN (1=1) THEN
726: into HZ_BES_GT ( event_id, party_id, bo_code, event_type_flag)

Line 724: 'HZ_PARTIES', party_id, BO_CODE, party_id)

720: PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE, child_event_id)
721: VALUES (
722: 'HZ_PARTIES', party_id, 'U', 'Y',
723: l_cc_start_time, C_BO_CODE, l_cc_start_time,
724: 'HZ_PARTIES', party_id, BO_CODE, party_id)
725: WHEN (1=1) THEN
726: into HZ_BES_GT ( event_id, party_id, bo_code, event_type_flag)
727: VALUES (
728: DECODE (G_BLK_EVT_RAISE, 'Y',

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'

Line 765: AND bot.CHILD_ENTITY_NAME (+) = 'HZ_PARTIES'

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'
766: AND bot.CHILD_ID(+) = r.PARTY_ID
767: AND bot.CHILD_BO_CODE(+) = r.BO_CODE
768: AND bot.parent_bo_code(+) IS NULL ;
769: COMMIT;

Line 1404: LOG('Updating hz_parties for future short circuiting');

1400:
1401: END LOOP; -- end of loop for raising one event per object instance
1402: END IF; -- end of check to raise bulk event or not
1403:
1404: LOG('Updating hz_parties for future short circuiting');
1405: LOG( 'Person Business Object bo_version_number is: '||G_PER_BO_VER);
1406: LOG( 'Organization Business Object bo_version_number is: '||G_ORG_BO_VER);
1407: LOG( 'Person Customer Business Object bo_version_number is: '||G_PER_CUST_BO_VER);
1408: LOG( 'Organization Customer Business Object bo_version_number is: '||G_ORG_CUST_BO_VER);

Line 1409: -- update the hz_parties bo_version number - so that any future

1405: LOG( 'Person Business Object bo_version_number is: '||G_PER_BO_VER);
1406: LOG( 'Organization Business Object bo_version_number is: '||G_ORG_BO_VER);
1407: LOG( 'Person Customer Business Object bo_version_number is: '||G_PER_CUST_BO_VER);
1408: LOG( 'Organization Customer Business Object bo_version_number is: '||G_ORG_CUST_BO_VER);
1409: -- update the hz_parties bo_version number - so that any future
1410: -- runs of this concurrent program can figure out the event type by short circuiting
1411: HZ_BES_BO_UTIL_PKG.upd_hzp_bo_ver (
1412: p_per_bo_ver => G_PER_BO_VER, -- for passing the person bo version number
1413: p_org_bo_ver => G_ORG_BO_VER, -- for passing the org bo version number