DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on CE_SECURITY_PROFILES_V

Line 530: | based on ce_security_profiles_v. The ce_security_profiles_tmp table |

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);

Line 561: from ce_security_profiles_v;

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;

Line 572: | based on security logic in ce_security_profiles_v except for BG. |

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

Line 590: from ce_security_profiles_v

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