APPS.ASO_BI_UTIL_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 19: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

15: BEGIN
16:
17: -- Find the schema owner and tablespace
18: -- ASO_BI_QUOTE_HDRS_ALL is using
19: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
20: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');
21: END IF;
22:
23: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema))

Line 20: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');

16:
17: -- Find the schema owner and tablespace
18: -- ASO_BI_QUOTE_HDRS_ALL is using
19: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
20: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');
21: END IF;
22:
23: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema))
24: THEN

Line 25: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

21: END IF;
22:
23: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema))
24: THEN
25: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
26: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);
27: END IF;
28: END IF;
29:

Line 26: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);

22:
23: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema))
24: THEN
25: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
26: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);
27: END IF;
28: END IF;
29:
30: END INIT;

Line 42: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

38: BEGIN
39: l_stmt := 'TRUNCATE table '||g_aso_schema||'.'||p_table_name;
40:
41: EXECUTE IMMEDIATE l_stmt;
42: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
43: BIS_COLLECTION_UTILITIES.Debug('Truncated table :' || p_table_name);
44: END IF;
45:
46: EXCEPTION

Line 43: BIS_COLLECTION_UTILITIES.Debug('Truncated table :' || p_table_name);

39: l_stmt := 'TRUNCATE table '||g_aso_schema||'.'||p_table_name;
40:
41: EXECUTE IMMEDIATE l_stmt;
42: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
43: BIS_COLLECTION_UTILITIES.Debug('Truncated table :' || p_table_name);
44: END IF;
45:
46: EXCEPTION
47: WHEN G_TABLE_NOT_EXIST THEN

Line 63: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

59: BEGIN
60:
61: l_table_name := p_table_name;
62: IF (g_aso_schema IS NULL) Then
63: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
64: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');
65: END IF;
66:
67: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema)) THEN

Line 64: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');

60:
61: l_table_name := p_table_name;
62: IF (g_aso_schema IS NULL) Then
63: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
64: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');
65: END IF;
66:
67: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema)) THEN
68: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 68: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

64: BIS_COLLECTION_UTILITIES.DEBUG('Getting APP info.');
65: END IF;
66:
67: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema)) THEN
68: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
69: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);
70: END IF;
71: END IF;
72: END IF;

Line 69: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);

65: END IF;
66:
67: IF(FND_INSTALLATION.GET_APP_INFO('ASO', l_status, l_industry, g_aso_schema)) THEN
68: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
69: BIS_COLLECTION_UTILITIES.DEBUG('g_aso_schema is '||g_aso_schema);
70: END IF;
71: END IF;
72: END IF;
73:

Line 74: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

70: END IF;
71: END IF;
72: END IF;
73:
74: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
75: BIS_COLLECTION_UTILITIES.Debug('Analyzing the table:'||l_table_name);
76: END IF;
77:
78: fnd_stats.gather_table_stats (ownname=>g_aso_schema,

Line 75: BIS_COLLECTION_UTILITIES.Debug('Analyzing the table:'||l_table_name);

71: END IF;
72: END IF;
73:
74: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
75: BIS_COLLECTION_UTILITIES.Debug('Analyzing the table:'||l_table_name);
76: END IF;
77:
78: fnd_stats.gather_table_stats (ownname=>g_aso_schema,
79: tabname=>l_table_name);