[Home] [Help]
PACKAGE: APPS.MSD_CS_DEFN_UTL2
Source
1 package msd_cs_defn_utl2 AUTHID CURRENT_USER as
2 /* $Header: msdcsu2s.pls 115.7 2003/11/04 18:39:21 dkang ship $ */
3
4 Type G_TYPE_DEFN_PARA_REC is
5 RECORD ( PARA_NAME MSD_CS_DEFINITIONS.name%TYPE,
6 PARA_TYPE MSD_CS_DEFINITIONS.CS_TYPE%TYPE,
7 VS_NAME varchar2(240),
8 SQL_STMT varchar2(2000),
9 MULTI_INPUT_FLAG varchar2(30),
10 MESSAGE varchar2(2000),
11 DEFAULT_VAL varchar2(240),
12 DEFAULT_CODE varchar2(30));
13
14
15 Type G_TYPE_DEFN_PARA_REC_LIST is TABLE of G_TYPE_DEFN_PARA_REC ;
16
17
18 Procedure build_para_list (
19 p_instance in number,
20 p_coll_cond in varchar2,
21 p_pull_cond in varchar2);
22
23 Procedure build_para_list (
24 p_instance in number,
25 p_coll_cond in varchar2,
26 p_pull_cond in varchar2,
27 p_defn_para_list in out NOCOPY g_type_defn_para_rec_list);
28
29 Procedure build_gen_para_list ( p_instance in number,
30 p_cond in varchar2,
31 p_defn_para_list in out NOCOPY g_type_defn_para_rec_list);
32
33 Function counts return number;
34
35 Procedure get_rec (
36 p_index in number,
37 p_message in out NOCOPY varchar2,
38 p_type in out NOCOPY varchar2,
39 p_sql_stmt IN OUT NOCOPY varchar2,
40 p_multi_flag in out nocopy varchar2,
41 p_default_code in out nocopy varchar2,
42 p_default_val in out nocopy varchar2);
43
44
45 Function get_char_property( p_cond varchar2,
46 p_start_pos number,
47 p_end_pos number,
48 p_index number) return varchar2;
49
50 Function genereate_sql_from_vs( p_vs_name IN varchar2,
51 p_dblink IN varchar2,
52 p_val_col IN OUT nocopy varchar2,
53 p_id_col IN OUT nocopy varchar2) return varchar2;
54
55 Function get_default_value (p_val_col IN varchar2,
56 p_id_col IN varchar2,
57 p_sql_stmt IN varchar2,
58 p_default_code IN varchar2) return varchar2;
59
60
61 End;