526: | PUBLIC PRECEDURE init_security |
527: | |
528: | DESCRIPTION |
529: | This procedure populates global temp table, ce_security_profiles_tmp,|
530: | based on ce_security_profiles_v. The ce_security_profiles_tmp table |
531: | is referenced from ce_bank_accts_gt_v. |
532: +=======================================================================*/
533: PROCEDURE init_security IS
534: l_appl_name VARCHAR2(50);
557: name)
558: select organization_type,
559: organization_id,
560: name
561: from ce_security_profiles_v;
562: EXCEPTION
563: WHEN OTHERS THEN
564: null;
565: END init_security;
568: | PUBLIC PRECEDURE init_security_baui |
569: | |
570: | DESCRIPTION |
571: | This procedure populates global temp table, ce_security_profiles_tmp,|
572: | based on security logic in ce_security_profiles_v except for BG. |
573: | All available BG will be populated to ce_security_profiles_tmp table |
574: +=======================================================================*/
575: PROCEDURE init_security_baui IS
576: BEGIN
586: name)
587: ( select organization_type,
588: organization_id,
589: name
590: from ce_security_profiles_v
591: union
592: select 'BUSINESS_GROUP',
593: org.BUSINESS_GROUP_ID,
594: org.NAME