APPS.XLA_SOURCES_PKG dependencies on XLA_SOURCE_PARAMS

Line 1247: FROM xla_source_params

1243:
1244: CURSOR check_source_params
1245: IS
1246: SELECT 'x'
1247: FROM xla_source_params
1248: WHERE ref_source_application_id = p_application_id
1249: AND ref_source_code = p_source_code
1250: AND ref_source_type_code = p_source_type_code;
1251:

Line 2077: FROM xla_source_params p

2073: IS
2074: SELECT application_id, source_type_code, source_code
2075: FROM xla_sources_b r
2076: WHERE exists (SELECT 'x'
2077: FROM xla_source_params p
2078: WHERE p.ref_source_application_id = p_application_id
2079: AND p.ref_source_code = p_source_code
2080: AND p.ref_source_type_code = p_source_type_code
2081: AND p.application_id = r.application_id

Line 2566: FROM xla_source_params p

2562: IS
2563: SELECT application_id, source_type_code, source_code
2564: FROM xla_sources_b r
2565: WHERE exists (SELECT 'x'
2566: FROM xla_source_params p
2567: WHERE p.ref_source_application_id = p_application_id
2568: AND p.ref_source_code = p_source_code
2569: AND p.ref_source_type_code = p_source_type_code
2570: AND p.application_id = r.application_id

Line 2837: FROM xla_source_params

2833: ,p_level => C_LEVEL_STATEMENT);
2834: END IF;
2835:
2836: DELETE
2837: FROM xla_source_params
2838: WHERE application_id = p_application_id
2839: AND source_type_code = p_source_type_code
2840: AND source_code = p_source_code;
2841:

Line 2897: FROM xla_source_params r

2893:
2894: CURSOR check_header_source
2895: IS
2896: SELECT 'x'
2897: FROM xla_source_params r
2898: WHERE application_id = p_application_id
2899: AND source_code = p_derived_source_code
2900: AND source_type_code = p_derived_source_type_code
2901: AND ref_source_code is not null

Line 2916: FROM xla_source_params r

2912:
2913: CURSOR check_line_source
2914: IS
2915: SELECT 'x'
2916: FROM xla_source_params r
2917: WHERE application_id = p_application_id
2918: AND source_code = p_derived_source_code
2919: AND source_type_code = p_derived_source_type_code
2920: AND ref_source_code is not null

Line 3253: FROM xla_source_params p

3249: IS
3250: SELECT application_id, source_type_code, source_code
3251: FROM xla_sources_b r
3252: WHERE exists (SELECT 'x'
3253: FROM xla_source_params p
3254: WHERE p.ref_source_application_id = p_application_id
3255: AND p.ref_source_code = p_source_code
3256: AND p.ref_source_type_code = p_source_type_code
3257: AND p.application_id = r.application_id

Line 3454: FROM xla_source_params p

3450: IS
3451: SELECT application_id, source_type_code, source_code
3452: FROM xla_sources_b r
3453: WHERE exists (SELECT 'x'
3454: FROM xla_source_params p
3455: WHERE p.ref_source_application_id = p_application_id
3456: AND p.ref_source_code = p_source_code
3457: AND p.ref_source_type_code = p_source_type_code
3458: AND p.application_id = r.application_id

Line 3782: FROM xla_source_params r

3778:
3779: CURSOR class_source
3780: IS
3781: SELECT 'x'
3782: FROM xla_source_params r
3783: WHERE application_id = p_application_id
3784: AND source_code = p_derived_source_code
3785: AND source_type_code = p_derived_source_type_code
3786: AND ref_source_code is not null

Line 3800: FROM xla_source_params r

3796:
3797: CURSOR lc_source
3798: IS
3799: SELECT 'x'
3800: FROM xla_source_params r
3801: WHERE application_id = p_application_id
3802: AND source_code = p_derived_source_code
3803: AND source_type_code = p_derived_source_type_code
3804: AND ref_source_code is not null

Line 3819: FROM xla_source_params r

3815:
3816: CURSOR line_source
3817: IS
3818: SELECT 'x'
3819: FROM xla_source_params r
3820: WHERE application_id = p_application_id
3821: AND source_code = p_derived_source_code
3822: AND source_type_code = p_derived_source_type_code
3823: AND ref_source_code is not null