APPS.HZ_BES_BO_RAISE_PKG dependencies on HZ_BES_GT

Line 339: FROM hz_bes_gt

335: AND root_node_flag = 'Y';
336:
337: CURSOR c_bo_gt IS
338: SELECT event_id, party_id, bo_code, event_type_flag
339: FROM hz_bes_gt
340: ORDER BY bo_code asc ;
341:
342: -- debug code start
343: CURSOR c_bo_gt_debug IS

Line 345: FROM hz_bes_gt

341:
342: -- debug code start
343: CURSOR c_bo_gt_debug IS
344: SELECT event_id, party_id, bo_code, event_type_flag
345: FROM hz_bes_gt
346: ORDER BY event_id, bo_code desc ;
347:
348: CURSOR c_bo_gt_debug2 (cp_bo_code VARCHAR2) IS
349: SELECT event_id, party_id, event_type_flag

Line 350: FROM hz_bes_gt

346: ORDER BY event_id, bo_code desc ;
347:
348: CURSOR c_bo_gt_debug2 (cp_bo_code VARCHAR2) IS
349: SELECT event_id, party_id, event_type_flag
350: FROM hz_bes_gt
351: WHERE bo_code = cp_bo_code
352: ORDER BY event_type_flag, event_id, party_id desc ;
353: -- debug code end
354:

Line 359: FROM hz_bes_gt

355: /* Cusror to figure out what types of bulk update events to be raised
356: */
357: CURSOR c_chk_insevt (cp_bo_code VARCHAR2) IS
358: SELECT 'Y'
359: FROM hz_bes_gt
360: WHERE BO_CODE = cp_bo_code
361: AND event_type_flag IS NULL
362: AND ROWNUM <2;
363:

Line 368: FROM hz_bes_gt

364: /* Cusror to figure out what types of bulk insert events to be raised
365: */
366: CURSOR c_chk_updevt (cp_bo_code VARCHAR2) IS
367: SELECT 'Y'
368: FROM hz_bes_gt
369: WHERE BO_CODE = cp_bo_code
370: AND event_type_flag = 'U'
371: AND ROWNUM <2;
372:

Line 551: INSERT INTO hz_bes_gt (event_id, party_id, BO_CODE, event_type_flag)

547: earlier i.e., candidates for updateBO event (event_type_flag).
548: */
549:
550: LOG('insert into GT the root nodes with short circuting');
551: INSERT INTO hz_bes_gt (event_id, party_id, BO_CODE, event_type_flag)
552: SELECT
553: DECODE ( G_BLK_EVT_RAISE, 'Y',
554: CASE r.bo_code
555: WHEN G_PER_BO_CODE THEN

Line 726: into HZ_BES_GT ( event_id, party_id, bo_code, event_type_flag)

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',
729: CASE bo_code
730: WHEN G_ORG_CUST_BO_CODE THEN

Line 751: hz_bes_gt t1

747: t1.party_id party_id,
748: DECODE (t1.bo_code, 'PERSON', 'PERSON_CUST', 'ORG','ORG_CUST') BO_CODE,
749: t1.bo_code C_BO_CODE
750: FROM
751: hz_bes_gt t1
752: WHERE
753: t1.bo_code IN ('PERSON','ORG')
754: AND NOT EXISTS
755: ( SELECT t2.party_id

Line 756: FROM hz_bes_gt t2

752: WHERE
753: t1.bo_code IN ('PERSON','ORG')
754: AND NOT EXISTS
755: ( SELECT t2.party_id
756: FROM hz_bes_gt t2
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)