DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on CE_SECURITY_PROFILES_V

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

529: | PUBLIC PRECEDURE init_security |
530: | |
531: | DESCRIPTION |
532: | This procedure populates global temp table, ce_security_profiles_tmp,|
533: | based on ce_security_profiles_v. The ce_security_profiles_tmp table |
534: | is referenced from ce_bank_accts_gt_v. |
535: +=======================================================================*/
536: PROCEDURE init_security IS
537: l_resp_appl_id NUMBER(15); -- 8823179: Added variable

Line 571: from ce_security_profiles_v;

567: name)
568: select organization_type,
569: organization_id,
570: name
571: from ce_security_profiles_v;
572: EXCEPTION
573: WHEN OTHERS THEN
574: null;
575: END init_security;

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

578: | PUBLIC PRECEDURE init_security_baui |
579: | |
580: | DESCRIPTION |
581: | This procedure populates global temp table, ce_security_profiles_tmp,|
582: | based on security logic in ce_security_profiles_v except for BG. |
583: | All available BG will be populated to ce_security_profiles_tmp table |
584: +=======================================================================*/
585: PROCEDURE init_security_baui IS
586: BEGIN

Line 600: from ce_security_profiles_v

596: name)
597: ( select organization_type,
598: organization_id,
599: name
600: from ce_security_profiles_v
601: union
602: select 'BUSINESS_GROUP',
603: org.BUSINESS_GROUP_ID,
604: org.NAME