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.29.12020000.2 2012/10/22 09:18:45 vkanteti 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 310: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_source_pkg';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2757: (p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num)

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

Line 2980: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

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

Line 3049: ,'xla_cmp_source_pkg.GenerateGetMeaningFct'

3045: xla_exceptions_pkg.raise_message
3046: ('XLA'
3047: ,'XLA_CMP_COMPILER_ERROR'
3048: ,'PROCEDURE'
3049: ,'xla_cmp_source_pkg.GenerateGetMeaningFct'
3050: ,'ERROR'
3051: , sqlerrm
3052: );
3053:

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

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

Line 3070: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

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

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

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

Line 3146: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

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

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

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

Line 3264: END xla_cmp_source_pkg;

3260: g_log_level := C_LEVEL_LOG_DISABLED;
3261: END IF;
3262:
3263: --
3264: END xla_cmp_source_pkg;