DBA Data[Home] [Help]

SYSTEM.AD_APPS_PRIVATE dependencies on STANDARD

Line 1869: 'STANDARD_EXCEPTION',

1865: -- Check to see if this is an active exception object
1866:
1867: if matching_exception_object(base_schema, rtrim(drop_rec.object_name),
1868: rtrim(drop_rec.object_type),
1869: 'STANDARD_EXCEPTION',
1870: apps_schema, found_cust, cust_correct,
1871: cust_row_index) then
1872: --
1873: -- Active 'STANDARD_EXCEPTION' exception object

Line 1873: -- Active 'STANDARD_EXCEPTION' exception object

1869: 'STANDARD_EXCEPTION',
1870: apps_schema, found_cust, cust_correct,
1871: cust_row_index) then
1872: --
1873: -- Active 'STANDARD_EXCEPTION' exception object
1874: --
1875: -- If customized object in APPS exists and is a synonym, drop it.
1876: -- Otherwise, don't do anything
1877: --

Line 1914: 'STANDARD_EXCEPTION',

1910: -- (re)create synonym if not an active exception object
1911:
1912: if not matching_exception_object(base_schema, rtrim(syn_rec.object_name),
1913: rtrim(syn_rec.object_type),
1914: 'STANDARD_EXCEPTION',
1915: apps_schema, found_cust, cust_correct,
1916: cust_row_index) then
1917: -- not an active exception object. Calculate the replace_existing_syn flag.
1918: Select decode (Computed_Value.Val,1,'TRUE','FALSE') into replace_existing_syn_tmp

Line 1962: 'STANDARD_EXCEPTION',

1958: -- Check to see if this is an active exception object
1959:
1960: if matching_exception_object(base_schema, rtrim(excpt_rec.object_name),
1961: rtrim(excpt_rec.object_type),
1962: 'STANDARD_EXCEPTION',
1963: apps_schema, found_cust, cust_correct,
1964: cust_row_index) then
1965: --
1966: -- Active 'STANDARD_EXCEPTION' exception object

Line 1966: -- Active 'STANDARD_EXCEPTION' exception object

1962: 'STANDARD_EXCEPTION',
1963: apps_schema, found_cust, cust_correct,
1964: cust_row_index) then
1965: --
1966: -- Active 'STANDARD_EXCEPTION' exception object
1967: --
1968: -- if customized object does not exist
1969: -- if not synonym, fatal error
1970: -- if synonym, create it

Line 3354: -- STANDARD_EXCEPTION

3350: -- exception_type
3351: --
3352: -- Type of exception. One of the following:
3353: --
3354: -- STANDARD_EXCEPTION
3355: --
3356: -- Possibly this is the only exception type we will ever support,
3357: -- but I wanted to leave it open for future expansion
3358: --

Line 3422: -- exception_type(list_count) := 'STANDARD_EXCEPTION';

3418: -- list_count := list_count + 1;
3419: -- prod_short_name(list_count) := 'PER';
3420: -- base_name(list_count) := 'PER_ASSIGNMENT_BUDGET_VALUES';
3421: -- base_type(list_count) := 'TABLE';
3422: -- exception_type(list_count) := 'STANDARD_EXCEPTION';
3423: -- trigger_obj_schema(list_count ) := 'APPS';
3424: -- trigger_obj_type(list_count) := 'VIEW';
3425: -- trigger_obj_name(list_count) := 'PER_ASG_BUDGET_VALS_INTNL';
3426: -- apps_name(list_count) := 'PER_ASSIGNMENT_BUDGET_VALUES';

Line 3437: -- exception_type(list_count) := 'STANDARD_EXCEPTION';

3433: -- list_count := list_count + 1;
3434: -- prod_short_name(list_count) := 'SQLAP';
3435: -- base_name(list_count) := 'JG_ZZ_VEND_SITE_INFO';
3436: -- base_type(list_count) := 'TABLE';
3437: -- exception_type(list_count) := 'STANDARD_EXCEPTION';
3438: -- trigger_obj_schema(list_count ) := 'APPS';
3439: -- trigger_obj_type(list_count) := 'VIEW';
3440: -- trigger_obj_name(list_count) := 'JG_ZZ_VEND_SITE_INFO_V';
3441: -- apps_name(list_count) := 'JG_ZZ_VEND_SITE_INFO';

Line 3456: exception_type(list_count) := 'STANDARD_EXCEPTION';

3452: list_count := list_count + 1;
3453: prod_short_name(list_count) := 'AR';
3454: base_name(list_count) := 'RA_CONTACTS';
3455: base_type(list_count) := 'TABLE';
3456: exception_type(list_count) := 'STANDARD_EXCEPTION';
3457: trigger_obj_schema(list_count ) := 'APPS';
3458: trigger_obj_type(list_count) := 'VIEW';
3459: trigger_obj_name(list_count) := 'RA_HCONTACTS';
3460: apps_name(list_count) := 'RA_CONTACTS';

Line 3471: exception_type(list_count) := 'STANDARD_EXCEPTION';

3467: list_count := list_count + 1;
3468: prod_short_name(list_count) := 'AR';
3469: base_name(list_count) := 'AR_CUST_PROF_CLASS_AMOUNTS';
3470: base_type(list_count) := 'TABLE';
3471: exception_type(list_count) := 'STANDARD_EXCEPTION';
3472: trigger_obj_schema(list_count ) := 'APPS';
3473: trigger_obj_type(list_count) := 'VIEW';
3474: trigger_obj_name(list_count) := 'AR_HCUST_PROF_CLASS_AMOUNTS';
3475: apps_name(list_count) := 'AR_CUST_PROF_CLASS_AMOUNTS';

Line 3486: exception_type(list_count) := 'STANDARD_EXCEPTION';

3482: list_count := list_count + 1;
3483: prod_short_name(list_count) := 'AR';
3484: base_name(list_count) := 'AR_CUSTOMER_PROFILES';
3485: base_type(list_count) := 'TABLE';
3486: exception_type(list_count) := 'STANDARD_EXCEPTION';
3487: trigger_obj_schema(list_count ) := 'APPS';
3488: trigger_obj_type(list_count) := 'VIEW';
3489: trigger_obj_name(list_count) := 'AR_HCUSTOMER_PROFILES';
3490: apps_name(list_count) := 'AR_CUSTOMER_PROFILES';

Line 3501: exception_type(list_count) := 'STANDARD_EXCEPTION';

3497: list_count := list_count + 1;
3498: prod_short_name(list_count) := 'AR';
3499: base_name(list_count) := 'RA_CONTACT_ROLES';
3500: base_type(list_count) := 'TABLE';
3501: exception_type(list_count) := 'STANDARD_EXCEPTION';
3502: trigger_obj_schema(list_count ) := 'APPS';
3503: trigger_obj_type(list_count) := 'VIEW';
3504: trigger_obj_name(list_count) := 'RA_HCONTACT_ROLES';
3505: apps_name(list_count) := 'RA_CONTACT_ROLES';

Line 3516: exception_type(list_count) := 'STANDARD_EXCEPTION';

3512: list_count := list_count + 1;
3513: prod_short_name(list_count) := 'AR';
3514: base_name(list_count) := 'AR_CUSTOMER_PROFILE_AMOUNTS';
3515: base_type(list_count) := 'TABLE';
3516: exception_type(list_count) := 'STANDARD_EXCEPTION';
3517: trigger_obj_schema(list_count ) := 'APPS';
3518: trigger_obj_type(list_count) := 'VIEW';
3519: trigger_obj_name(list_count) := 'AR_HCUSTOMER_PROFILE_AMOUNTS';
3520: apps_name(list_count) := 'AR_CUSTOMER_PROFILE_AMOUNTS';

Line 3531: exception_type(list_count) := 'STANDARD_EXCEPTION';

3527: list_count := list_count + 1;
3528: prod_short_name(list_count) := 'AR';
3529: base_name(list_count) := 'AR_CUSTOMER_PROFILE_CLASSES';
3530: base_type(list_count) := 'TABLE';
3531: exception_type(list_count) := 'STANDARD_EXCEPTION';
3532: trigger_obj_schema(list_count ) := 'APPS';
3533: trigger_obj_type(list_count) := 'VIEW';
3534: trigger_obj_name(list_count) := 'AR_HCUSTOMER_PROFILE_CLASSES';
3535: apps_name(list_count) := 'AR_CUSTOMER_PROFILE_CLASSES';

Line 3546: exception_type(list_count) := 'STANDARD_EXCEPTION';

3542: list_count := list_count + 1;
3543: prod_short_name(list_count) := 'CZ';
3544: base_name(list_count) := 'CZ_INTL_TEXTS';
3545: base_type(list_count) := 'TABLE';
3546: exception_type(list_count) := 'STANDARD_EXCEPTION';
3547: trigger_obj_schema(list_count ) := 'APPS';
3548: trigger_obj_type(list_count) := 'VIEW';
3549: trigger_obj_name(list_count) := 'CZ_LOCALIZED_TEXTS_VL';
3550: apps_name(list_count) := 'CZ_INTL_TEXTS';

Line 3562: exception_type(list_count) := 'STANDARD_EXCEPTION';

3558: list_count := list_count + 1;
3559: prod_short_name(list_count) := 'AR';
3560: base_name(list_count) := 'HZ_CONTACT_RESTRICTIONS';
3561: base_type(list_count) := 'TABLE';
3562: exception_type(list_count) := 'STANDARD_EXCEPTION';
3563: trigger_obj_schema(list_count ) := 'APPS';
3564: trigger_obj_type(list_count) := 'VIEW';
3565: trigger_obj_name(list_count) := 'HZ_CONTACT_RESTRICTIONS';
3566: apps_name(list_count) := 'HZ_CONTACT_RESTRICTIONS';

Line 3578: exception_type(list_count) := 'STANDARD_EXCEPTION';

3574: list_count := list_count + 1;
3575: prod_short_name(list_count) := 'AR';
3576: base_name(list_count) := 'HZ_PARTY_RELATIONSHIPS';
3577: base_type(list_count) := 'TABLE';
3578: exception_type(list_count) := 'STANDARD_EXCEPTION';
3579: trigger_obj_schema(list_count ) := 'APPS';
3580: trigger_obj_type(list_count) := 'VIEW';
3581: trigger_obj_name(list_count) := 'HZ_PARTY_RELATIONSHIPS';
3582: apps_name(list_count) := 'HZ_PARTY_RELATIONSHIPS';

Line 3594: exception_type(list_count) := 'STANDARD_EXCEPTION';

3590: list_count := list_count + 1;
3591: prod_short_name(list_count) := 'JTF';
3592: base_name(list_count) := 'JTF_TASK_ASSIGNMENTS';
3593: base_type(list_count) := 'TABLE';
3594: exception_type(list_count) := 'STANDARD_EXCEPTION';
3595: trigger_obj_schema(list_count ) := 'APPS';
3596: trigger_obj_type(list_count) := 'VIEW';
3597: trigger_obj_name(list_count) := 'JTF_TASK_ASSIGNMENTS_V';
3598: apps_name(list_count) := 'JTF_TASK_ASSIGNMENTS';

Line 3610: exception_type(list_count) := 'STANDARD_EXCEPTION';

3606: list_count := list_count + 1;
3607: prod_short_name(list_count) := 'JTF';
3608: base_name(list_count) := 'JTF_RS_SRP_TERRITORIES';
3609: base_type(list_count) := 'TABLE';
3610: exception_type(list_count) := 'STANDARD_EXCEPTION';
3611: trigger_obj_schema(list_count ) := 'APPS';
3612: trigger_obj_type(list_count) := 'TABLE';
3613: trigger_obj_name(list_count) := 'JTF_RS_SRP_TERRITORIES';
3614: apps_name(list_count) := 'RA_SALESREP_TERRITORIES';

Line 3627: exception_type(list_count) := 'STANDARD_EXCEPTION';

3623: list_count := list_count + 1;
3624: prod_short_name(list_count) := 'ONT';
3625: base_name(list_count) := 'OE_SYSTEM_PARAMETERS_ALL';
3626: base_type(list_count) := 'TABLE';
3627: exception_type(list_count) := 'STANDARD_EXCEPTION';
3628: trigger_obj_schema(list_count ) := 'APPS';
3629: trigger_obj_type(list_count) := 'VIEW';
3630: trigger_obj_name(list_count) := 'OE_SYS_PARAMS_ALL_UPG';
3631: apps_name(list_count) := 'OE_SYSTEM_PARAMETERS_ALL';

Line 3642: exception_type(list_count) := 'STANDARD_EXCEPTION';

3638: list_count := list_count + 1;
3639: prod_short_name(list_count) := 'AR';
3640: base_name(list_count) := 'RA_CUSTOMERS';
3641: base_type(list_count) := 'TABLE';
3642: exception_type(list_count) := 'STANDARD_EXCEPTION';
3643: trigger_obj_schema(list_count ) := 'APPS';
3644: trigger_obj_type(list_count) := 'VIEW';
3645: trigger_obj_name(list_count) := 'RA_HCUSTOMERS';
3646: apps_name(list_count) := 'RA_CUSTOMERS';

Line 3657: exception_type(list_count) := 'STANDARD_EXCEPTION';

3653: list_count := list_count + 1;
3654: prod_short_name(list_count) := 'AR';
3655: base_name(list_count) := 'RA_PHONES';
3656: base_type(list_count) := 'TABLE';
3657: exception_type(list_count) := 'STANDARD_EXCEPTION';
3658: trigger_obj_schema(list_count ) := 'APPS';
3659: trigger_obj_type(list_count) := 'VIEW';
3660: trigger_obj_name(list_count) := 'RA_HPHONES';
3661: apps_name(list_count) := 'RA_PHONES';

Line 3672: exception_type(list_count) := 'STANDARD_EXCEPTION';

3668: list_count := list_count + 1;
3669: prod_short_name(list_count) := 'AR';
3670: base_name(list_count) := 'RA_ADDRESSES_ALL';
3671: base_type(list_count) := 'TABLE';
3672: exception_type(list_count) := 'STANDARD_EXCEPTION';
3673: trigger_obj_schema(list_count ) := 'APPS';
3674: trigger_obj_type(list_count) := 'VIEW';
3675: trigger_obj_name(list_count) := 'RA_ADDRESSES_MORG';
3676: apps_name(list_count) := 'RA_ADDRESSES_ALL';

Line 3687: exception_type(list_count) := 'STANDARD_EXCEPTION';

3683: list_count := list_count + 1;
3684: prod_short_name(list_count) := 'AR';
3685: base_name(list_count) := 'RA_CUSTOMER_RELATIONSHIPS_ALL';
3686: base_type(list_count) := 'TABLE';
3687: exception_type(list_count) := 'STANDARD_EXCEPTION';
3688: trigger_obj_schema(list_count ) := 'APPS';
3689: trigger_obj_type(list_count) := 'VIEW';
3690: trigger_obj_name(list_count) := 'RA_CUSTOMER_RELATIONSHIPS_MORG';
3691: apps_name(list_count) := 'RA_CUSTOMER_RELATIONSHIPS_ALL';

Line 3702: exception_type(list_count) := 'STANDARD_EXCEPTION';

3698: list_count := list_count + 1;
3699: prod_short_name(list_count) := 'AR';
3700: base_name(list_count) := 'RA_SITE_USES_ALL';
3701: base_type(list_count) := 'TABLE';
3702: exception_type(list_count) := 'STANDARD_EXCEPTION';
3703: trigger_obj_schema(list_count ) := 'APPS';
3704: trigger_obj_type(list_count) := 'VIEW';
3705: trigger_obj_name(list_count) := 'RA_SITE_USES_MORG';
3706: apps_name(list_count) := 'RA_SITE_USES_ALL';