eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FND_FLEX_TYPES

Source


1 PACKAGE fnd_flex_types AS
2 /* $Header: AFFFTYPS.pls 120.2.12010000.1 2008/07/25 14:14:35 appldev ship $ */
3 
4 
5 
6 bad_parameter EXCEPTION;
7 PRAGMA EXCEPTION_INIT(bad_parameter, -06501);
8 
9 
10 
11 -- check that a default type exists
12 -- @param code the code for the type
13 PROCEDURE validate_default_type(code IN VARCHAR2);
14 
15 /* flex default type */
16 -- default type; constant
17 def_constant CONSTANT VARCHAR2(1) := 'C';
18 -- default type; date
19 def_date     CONSTANT VARCHAR2(1) := 'D';
20 -- default type; time
21 def_time     CONSTANT VARCHAR2(1) := 'T';
22 -- default type; environment variable
23 def_envvar   CONSTANT VARCHAR2(1) := 'E';
24 -- default type; field
25 def_field    CONSTANT VARCHAR2(1) := 'F';
26 -- default type; profile
27 def_profile  CONSTANT VARCHAR2(1) := 'P';
28 -- default type; sql statement
29 def_sql      CONSTANT VARCHAR2(1) := 'S';
30 -- default type; segment
31 def_segment  CONSTANT VARCHAR2(1) := 'A';
32 
33 
34 
35 -- check that a range code exists
36 -- @param code the code for the type
37 PROCEDURE validate_range_code(code IN VARCHAR2);
38 
39 /* range codes */
40 -- range code; high
41 rng_high  CONSTANT VARCHAR2(1) := 'H';
42 -- range code; low
43 rng_low   CONSTANT VARCHAR2(1) := 'L';
44 -- range code; pair
45 rng_pair  CONSTANT VARCHAR2(1) := 'P';
46 
47 
48 
49 -- check that a field type code exists
50 -- @param code the code for the type
51 PROCEDURE validate_field_type(code IN VARCHAR2);
52 
53 /* field type */
54 -- field type; character
55 fld_char           CONSTANT VARCHAR2(1) := 'C';
56 -- field type; money
57 fld_money          CONSTANT VARCHAR2(1) := 'M';
58 -- field type; number
59 fld_number         CONSTANT VARCHAR2(1) := 'N';
60 -- field type; standard date
61 fld_std_date       CONSTANT VARCHAR2(1) := 'X';
62 -- field type; standard time
63 fld_std_time       CONSTANT VARCHAR2(1) := 'Z';
64 -- field type; standart date-time
65 fld_std_datetime   CONSTANT VARCHAR2(1) := 'Y';
66 -- field type; old style date
67 fld_old_date       CONSTANT VARCHAR2(1) := 'D';
68 -- field type; old style time
69 fld_old_time       CONSTANT VARCHAR2(1) := 'I';
70 -- field type; old style datatime
71 fld_old_datetime   CONSTANT VARCHAR2(1) := 'T';
72 
73 
74 
75 -- check that a segment validation type code exists
76 -- @param code the code for the type
77 PROCEDURE validate_segval_type(code IN VARCHAR2);
78 
79 /* seg_val_types */
80 -- segment validation; dependent
81 val_dependent    CONSTANT VARCHAR2(1) := 'D';
82 -- segment validation; indendent
83 val_independent  CONSTANT VARCHAR2(1) := 'I';
84 -- segment validation; none
85 val_none         CONSTANT VARCHAR2(1) := 'N';
86 -- segment validation; pair
87 val_pair         CONSTANT VARCHAR2(1) := 'P';
88 -- segment validation; special
89 val_special      CONSTANT VARCHAR2(1) := 'U';
90 -- segment validation; table
91 val_table        CONSTANT VARCHAR2(1) := 'F';
92 
93 
94 
95 -- check that a event type code exists
96 -- @param code the code for the type
97 PROCEDURE validate_event_type(code IN VARCHAR2);
98 
99 /* flex validation events */
100 -- validation event type; edit event
101 evt_edit           CONSTANT VARCHAR2(1) := 'E';
102 -- validation event type; edit/edit
103 evt_edit_edit      CONSTANT VARCHAR2(1) := 'O';
104 -- validation event type; insert/update
105 evt_insert_update  CONSTANT VARCHAR2(1) := 'I';
106 -- validation event type; listval
107 evt_listval        CONSTANT VARCHAR2(1) := 'Q';
108 -- validation event type; load
109 evt_load           CONSTANT VARCHAR2(1) := 'L';
110 -- validation event type; query
111 evt_query          CONSTANT VARCHAR2(1) := 'F';
112 -- validation event type; validate
113 evt_validate       CONSTANT VARCHAR2(1) := 'V';
114 
115 
116 
117 -- check that a column type code exists
118 -- @param code the code for the type
119 PROCEDURE validate_column_type(code IN VARCHAR2);
120 
121 /* column type */
122 -- column type; character
123 col_char         CONSTANT VARCHAR2(1) := 'C';
124 -- column type; date
125 col_date         CONSTANT VARCHAR2(1) := 'D';
126 -- column type; long
127 col_long         CONSTANT VARCHAR2(1) := 'L';
128 -- column type; long raw
129 col_long_raw     CONSTANT VARCHAR2(1) := 'X';
130 -- column type; mlslabel
131 col_mlslabel     CONSTANT VARCHAR2(1) := 'M';
132 -- column type; number
133 col_number       CONSTANT VARCHAR2(1) := 'N';
134 -- column type; raw
135 col_raw          CONSTANT VARCHAR2(1) := 'R';
136 -- column type; raw mlslabel
137 col_raw_mlslabel CONSTANT VARCHAR2(1) := 'Z';
138 -- column type; rowid
139 col_rowid        CONSTANT VARCHAR2(1) := 'I';
140 -- column type; varchar
141 col_varchar      CONSTANT VARCHAR2(1) := 'U';
142 -- column type; varchar2
143 col_varchar2     CONSTANT VARCHAR2(1) := 'V';
144 
145 
146 
147 -- check that a yes_no code exists
148 -- @param code is the code for the type
149 PROCEDURE validate_yes_no_flag(code IN VARCHAR2);
150 
151 /* yes_no type */
152 -- flag ; yes
153 flag_yes   CONSTANT VARCHAR2(1) := 'Y';
154 -- flag ; no
155 flag_no    CONSTANT VARCHAR2(1) := 'N';
156 
157 -- given a description of a code, try and find the
158 -- the code.
159 FUNCTION get_code(typ IN VARCHAR2, descr IN VARCHAR2) RETURN VARCHAR2;
160 
161 
162 FUNCTION ad_dd_used_by_flex(p_application_id IN fnd_tables.application_id%TYPE,
163 			    p_table_name     IN fnd_tables.table_name%TYPE,
164 			    p_column_name    IN fnd_columns.column_name%TYPE,
165 			    x_message        OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
166 
167 END fnd_flex_types;			/* end package */