DBA Data[Home] [Help]

PACKAGE: APPS.AST_NOTE_PACKAGE

Source


1 PACKAGE ast_note_package AUTHID CURRENT_USER as
2 /* $Header: astnotes.pls 120.1 2005/06/01 03:39:16 appldev  $ */
3 -- Start of Comments
4 -- Package name     : ast_note_package
5 -- Purpose          : Function to provide Object details in the view AST_NOTE_CONTEXTS_V
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 procedure note_context_info (
11 	p_sql_statement IN varchar2,
12 	p_object_info IN OUT NOCOPY /* file.sql.39 change */ varchar2,
13 	p_object_id IN number);
14 
15 function note_context_info (
16 	p_select_id VARCHAR2,
17 	p_select_name VARCHAR2,
18 	p_select_details VARCHAR2,
19 	p_from_table VARCHAR2,
20 	p_where_clause VARCHAR2,
21 	p_object_id NUMBER)
22 return VARCHAR2;
23 
24 function party_type_info (
25 	p_object_id NUMBER)
26 return VARCHAR2;
27 
28 function read_clob (
29 	p_clob CLOB)
30 return VARCHAR2;
31 
32 function read_clob (
33 	p_note_id NUMBER)
34 return VARCHAR2;
35 
36 END;