APPS.AS_UTILITY_PVT dependencies on AS_UTILITY_PVT

Line 1: PACKAGE BODY AS_UTILITY_PVT as

1: PACKAGE BODY AS_UTILITY_PVT as
2: /* $Header: asxvutlb.pls 120.2 2007/03/16 08:17:08 snsarava ship $ */
3: --
4: -- NAME
5: -- AS_UTILITY_PVT

Line 5: -- AS_UTILITY_PVT

1: PACKAGE BODY AS_UTILITY_PVT as
2: /* $Header: asxvutlb.pls 120.2 2007/03/16 08:17:08 snsarava ship $ */
3: --
4: -- NAME
5: -- AS_UTILITY_PVT
6: --
7: -- HISTORY
8: -- 08/11/99 AWU CREATED(as AS_UTILITY)
9: -- 09/09/99 SOLIN UPDATED(change to JTF_PLSQL_API)

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_UTILITY_PVT';

12: -- in FND_MSG_PUB.Count_And_Get of
13: -- Handle_Exceptions()
14: -- 11/12/02 AXAVIER Bug#2659173 Changed the procedure Debug_Message.
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_UTILITY_PVT';
17: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvutlb.pls';
18:
19: pg_file_name VARCHAR2(100) := NULL;
20: pg_path_name VARCHAR2(100) := NULL;

Line 744: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type,

740: END IF;
741: END Set_Message;
742:
743: PROCEDURE Gen_Flexfield_Where(
744: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type,
745: x_flex_where_clause OUT NOCOPY VARCHAR2) IS
746: l_flex_where_cl VARCHAR2(2000) := NULL;
747: BEGIN
748: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 749: 'AS_UTILITY_PVT Generate Flexfield Where: begin');

745: x_flex_where_clause OUT NOCOPY VARCHAR2) IS
746: l_flex_where_cl VARCHAR2(2000) := NULL;
747: BEGIN
748: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
749: 'AS_UTILITY_PVT Generate Flexfield Where: begin');
750:
751: FOR i IN 1..p_flex_where_tbl_type.count LOOP
752: IF (p_flex_where_tbl_type(i).value IS NOT NULL
753: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

Line 761: 'AS_UTILITY_PVT Generate Flexfield Where: end');

757: END LOOP;
758: x_flex_where_clause := l_flex_where_cl;
759:
760: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
761: 'AS_UTILITY_PVT Generate Flexfield Where: end');
762: END;
763:
764: PROCEDURE Bind_Flexfield_Where(
765: p_cursor_id IN NUMBER,

Line 766: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type) IS

762: END;
763:
764: PROCEDURE Bind_Flexfield_Where(
765: p_cursor_id IN NUMBER,
766: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type) IS
767: BEGIN
768: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
769: 'AS_UTILITY_PVT Bind Flexfield Where: begin');
770:

Line 769: 'AS_UTILITY_PVT Bind Flexfield Where: begin');

765: p_cursor_id IN NUMBER,
766: p_flex_where_tbl_type IN AS_UTILITY_PVT.flex_where_tbl_type) IS
767: BEGIN
768: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
769: 'AS_UTILITY_PVT Bind Flexfield Where: begin');
770:
771: FOR i IN 1..p_flex_where_tbl_type.count LOOP
772: IF (p_flex_where_tbl_type(i).value IS NOT NULL
773: AND p_flex_where_tbl_type(i).value <> FND_API.G_MISS_CHAR) THEN

Line 780: 'AS_UTILITY_PVT Bind Flexfield Where: end');

776: END IF;
777: END LOOP;
778:
779: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
780: 'AS_UTILITY_PVT Bind Flexfield Where: end');
781: END;
782:
783:
784: PROCEDURE file_debug(line in varchar2) IS

Line 829: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_UTILITY_PVT Processing index: '||p_indRec.index_name );

825: ' STORAGE (INITIAL '||p_indRec.int_ext||'M NEXT '||p_indRec.next_ext ||'M MINEXTENTS '||
826: p_indRec.min_ext||' MAXEXTENTS '||p_indRec.max_ext ||' PCTINCREASE '||p_indRec.pct||
827: ' FREELISTS '||p_indRec.freelists||') PARALLEL '||get_degree_parallelism||
828: ' TABLESPACE '||p_indRec.ts;
829: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_UTILITY_PVT Processing index: '||p_indRec.index_name );
830:
831: UPDATE as_conc_request_messages
832: SET index_text = p_indRec.indSql
833: WHERE index_name = p_indRec.index_name

Line 990: END AS_UTILITY_PVT;

986: errbuf := 'Error in execute_ind processing table '||p_table_name||'with mode '||p_mode||': '||substr(sqlerrm,1,255);
987: retcode := -1;
988: END execute_ind;
989:
990: END AS_UTILITY_PVT;