DBA Data[Home] [Help]

APPS.XLA_CMP_SOURCE_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 1: PACKAGE BODY xla_cmp_source_pkg AS

1: PACKAGE BODY xla_cmp_source_pkg AS
2: /* $Header: xlacpscs.pkb 120.28 2006/04/04 20:54:30 wychan ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_cmp_source_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_cmp_source_pkg |
10: | |
11: | DESCRIPTION |
12: | This is a XLA private package, which contains all the logic required |
13: | to cache the sources and entities/objects defined in the AMB |

Line 307: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_source_pkg';

303: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
304: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
305:
306: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
307: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_source_pkg';
308:
309: g_log_level NUMBER;
310: g_log_enabled BOOLEAN;
311:

Line 331: (p_location => 'xla_cmp_source_pkg.trace');

327: WHEN xla_exceptions_pkg.application_exception THEN
328: RAISE;
329: WHEN OTHERS THEN
330: xla_exceptions_pkg.raise_message
331: (p_location => 'xla_cmp_source_pkg.trace');
332: END trace;
333: --
334:
335: /*-------------------------------------------------------+

Line 457: (p_location => 'xla_cmp_source_pkg.GetStandardSource');

453: END IF;
454: RETURN NULL;
455: WHEN OTHERS THEN
456: xla_exceptions_pkg.raise_message
457: (p_location => 'xla_cmp_source_pkg.GetStandardSource');
458: END GetStandardSource;
459:
460: /*----------------------------------------------------------+
461: | Private function |

Line 546: (p_location => 'xla_cmp_source_pkg.GetMeaningSource');

542: END IF;
543: RETURN 'NULL';
544: WHEN OTHERS THEN
545: xla_exceptions_pkg.raise_message
546: (p_location => 'xla_cmp_source_pkg.GetMeaningSource');
547: END GetMeaningSource;
548:
549: /*----------------------------------------------------------+
550: | Private function |

Line 648: (p_location => 'xla_cmp_source_pkg.GetSystemSource');

644: END IF;
645: RETURN NULL;
646: WHEN OTHERS THEN
647: xla_exceptions_pkg.raise_message
648: (p_location => 'xla_cmp_source_pkg.GetSystemSource');
649: END GetSystemSource;
650:
651: /*----------------------------------------------------------+
652: | Private function |

Line 818: (p_location => 'xla_cmp_source_pkg.GetCustomSource');

814: END IF;
815: RAISE;
816: WHEN OTHERS THEN
817: xla_exceptions_pkg.raise_message
818: (p_location => 'xla_cmp_source_pkg.GetCustomSource');
819: END GetCustomSource;
820:
821: /*----------------------------------------------------------+
822: | Private function |

Line 977: (p_location => 'xla_cmp_source_pkg.GetValueSetSource');

973: END IF;
974: RAISE;
975: WHEN OTHERS THEN
976: xla_exceptions_pkg.raise_message
977: (p_location => 'xla_cmp_source_pkg.GetValueSetSource');
978: END GetValueSetSource;
979:
980: /*----------------------------------------------------------+
981: | Private function |

Line 1193: (p_location => 'xla_cmp_source_pkg.GetLookupSource');

1189: END IF;
1190: RAISE;
1191: WHEN OTHERS THEN
1192: xla_exceptions_pkg.raise_message
1193: (p_location => 'xla_cmp_source_pkg.GetLookupSource');
1194: END GetLookupSource;
1195:
1196: /*----------------------------------------------------------+
1197: | Private function |

Line 1336: (p_location => 'xla_cmp_source_pkg.GetKeyFlexfieldSource');

1332: END IF;
1333: RAISE;
1334: WHEN OTHERS THEN
1335: xla_exceptions_pkg.raise_message
1336: (p_location => 'xla_cmp_source_pkg.GetKeyFlexfieldSource');
1337: END GetKeyFlexfieldSource ;
1338:
1339:
1340: /*----------------------------------------------------------+

Line 1495: (p_location => 'xla_cmp_source_pkg.GenerateSource');

1491: END IF;
1492: RAISE;
1493: WHEN OTHERS THEN
1494: xla_exceptions_pkg.raise_message
1495: (p_location => 'xla_cmp_source_pkg.GenerateSource');
1496: END GenerateSource;
1497:
1498:
1499: /*----------------------------------------------------------+

Line 1627: (p_location => 'xla_cmp_source_pkg.GenerateParameters ');

1623: END IF;
1624: RAISE;
1625: WHEN OTHERS THEN
1626: xla_exceptions_pkg.raise_message
1627: (p_location => 'xla_cmp_source_pkg.GenerateParameters ');
1628: END GenerateParameters;
1629:
1630: /*----------------------------------------------------------+
1631: | Public function |

Line 1695: (p_location => 'xla_cmp_source_pkg.get_obj_parm_for_tab ');

1691: END IF;
1692: RETURN NULL;
1693: WHEN OTHERS THEN
1694: xla_exceptions_pkg.raise_message
1695: (p_location => 'xla_cmp_source_pkg.get_obj_parm_for_tab ');
1696: END get_obj_parm_for_tab;
1697:
1698: --
1699: --===========================================================================

Line 1885: (p_location => 'xla_cmp_source_pkg.CacheCustomSource');

1881: WHEN OTHERS THEN
1882: IF source_cur%ISOPEN THEN CLOSE source_cur; END IF;
1883: p_rec_sources := l_rec_sources;
1884: xla_exceptions_pkg.raise_message
1885: (p_location => 'xla_cmp_source_pkg.CacheCustomSource');
1886: END CacheCustomSource;
1887:
1888: /*--------------------------------------------------------------+
1889: | Public function |

Line 2069: (p_location => 'xla_cmp_source_pkg.CacheSource');

2065: RAISE;
2066: WHEN OTHERS THEN
2067:
2068: xla_exceptions_pkg.raise_message
2069: (p_location => 'xla_cmp_source_pkg.CacheSource');
2070: END CacheSource;
2071:
2072: /*--------------------------------------------------------------+
2073: | Private function |

Line 2163: (p_location => 'xla_cmp_source_pkg.StackCustomSource');

2159: WHEN OTHERS THEN
2160: IF source_cur%ISOPEN THEN CLOSE source_cur; END IF;
2161: p_rec_sources := l_rec_sources;
2162: xla_exceptions_pkg.raise_message
2163: (p_location => 'xla_cmp_source_pkg.StackCustomSource');
2164: END StackCustomSource;
2165:
2166: /*--------------------------------------------------------------+
2167: | Public function |

Line 2259: (p_location => 'xla_cmp_source_pkg.StackSource');

2255: WHEN OTHERS THEN
2256: p_rec_sources := l_rec_sources;
2257: p_array_source_index := l_array_source_index;
2258: xla_exceptions_pkg.raise_message
2259: (p_location => 'xla_cmp_source_pkg.StackSource');
2260: END StackSource;
2261:
2262: --+==========================================================================+
2263: --| |

Line 2400: (p_location => 'xla_cmp_source_pkg.IsObjectInAADCache');

2396: END IF;
2397: RETURN FALSE;
2398: WHEN OTHERS THEN
2399: xla_exceptions_pkg.raise_message
2400: (p_location => 'xla_cmp_source_pkg.IsObjectInAADCache');
2401: END IsObjectInAADCache;
2402:
2403: /*--------------------------------------------------------------+
2404: | Public function |

Line 2498: (p_location => 'xla_cmp_source_pkg.CacheAADObject');

2494: END IF;
2495: RETURN NULL;
2496: WHEN OTHERS THEN
2497: xla_exceptions_pkg.raise_message
2498: (p_location => 'xla_cmp_source_pkg.CacheAADObject');
2499: END CacheAADObject;
2500:
2501:
2502: /*--------------------------------------------------------------+

Line 2581: (p_location => 'xla_cmp_source_pkg.GetSourcesInAADObject');

2577: END IF;
2578: RAISE;
2579: WHEN OTHERS THEN
2580: xla_exceptions_pkg.raise_message
2581: (p_location => 'xla_cmp_source_pkg.GetSourcesInAADObject');
2582: END GetSourcesInAADObject;
2583:
2584: /*======================================================================+
2585: | |

Line 2656: (p_location => 'xla_cmp_source_pkg.GetAADObjectPosition');

2652: END IF;
2653: RETURN NULL;
2654: WHEN OTHERS THEN
2655: xla_exceptions_pkg.raise_message
2656: (p_location => 'xla_cmp_source_pkg.GetAADObjectPosition');
2657: END GetAADObjectPosition;
2658: --
2659: --
2660: --+==========================================================================+

Line 2754: (p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num)

2750: | Returns true if source associated to flex value set exist |
2751: | |
2752: +======================================================================*/
2753: FUNCTION flex_values_exist
2754: (p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num)
2755: RETURN BOOLEAN
2756: IS
2757: l_return boolean:= FALSE;
2758: l_log_module VARCHAR2(240);

Line 2977: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

2973: --+==========================================================================+
2974: --
2975: FUNCTION GenerateGetMeaningFct(
2976: p_package_name IN VARCHAR2
2977: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
2978: )
2979: RETURN VARCHAR2
2980: IS
2981: --

Line 3046: ,'xla_cmp_source_pkg.GenerateGetMeaningFct'

3042: xla_exceptions_pkg.raise_message
3043: ('XLA'
3044: ,'XLA_CMP_COMPILER_ERROR'
3045: ,'PROCEDURE'
3046: ,'xla_cmp_source_pkg.GenerateGetMeaningFct'
3047: ,'ERROR'
3048: , sqlerrm
3049: );
3050:

Line 3055: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaningFct');

3051: WHEN xla_exceptions_pkg.application_exception THEN
3052: RETURN NULL;
3053: WHEN OTHERS THEN
3054: xla_exceptions_pkg.raise_message
3055: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaningFct');
3056: END GenerateGetMeaningFct;
3057:
3058: --+==========================================================================+
3059: --| |

Line 3067: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

3063: --
3064: --
3065: FUNCTION GenerateGetMeaning(
3066: p_package_name IN VARCHAR2
3067: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
3068: , p_IsCompiled IN OUT NOCOPY BOOLEAN
3069: )
3070: RETURN DBMS_SQL.VARCHAR2S
3071: IS

Line 3132: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaning');

3128: RETURN xla_cmp_string_pkg.g_null_varchar2s;
3129: WHEN OTHERS THEN
3130: p_IsCompiled := FALSE;
3131: xla_exceptions_pkg.raise_message
3132: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaning');
3133: END GenerateGetMeaning;
3134: --
3135: --+==========================================================================+
3136: --| |

Line 3143: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

3139: --+==========================================================================+
3140: --
3141: FUNCTION GenerateGetMeaningAPI(
3142: p_package_name IN VARCHAR2
3143: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
3144: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
3145: )
3146: RETURN BOOLEAN
3147: IS

Line 3219: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaningAPI');

3215: WHEN xla_exceptions_pkg.application_exception THEN
3216: RETURN FALSE;
3217: WHEN OTHERS THEN
3218: xla_exceptions_pkg.raise_message
3219: (p_location => 'xla_cmp_source_pkg.GenerateGetMeaningAPI');
3220: END GenerateGetMeaningAPI;
3221: --=============================================================================
3222: --
3223: --

Line 3261: END xla_cmp_source_pkg;

3257: g_log_level := C_LEVEL_LOG_DISABLED;
3258: END IF;
3259:
3260: --
3261: END xla_cmp_source_pkg;