DBA Data[Home] [Help]

APPS.JTF_CTM_UTILITY_PVT dependencies on FND_API

Line 84: col_choice NUMBER := FND_API.G_MISS_NUM,

80: -- End of Comments
81:
82: TYPE util_order_by_rec_type IS RECORD
83: (
84: col_choice NUMBER := FND_API.G_MISS_NUM,
85: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
86: );
87:
88: TYPE util_order_by_tbl_type IS TABLE OF util_order_by_rec_type

Line 85: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR

81:
82: TYPE util_order_by_rec_type IS RECORD
83: (
84: col_choice NUMBER := FND_API.G_MISS_NUM,
85: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
86: );
87:
88: TYPE util_order_by_tbl_type IS TABLE OF util_order_by_rec_type
89: INDEX BY BINARY_INTEGER;

Line 115: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,

111:
112:
113: TYPE util_View_Columns_Rec_type IS RECORD
114: (
115: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
116: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
117: col_alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
118: col_name VARCHAR2(70) := FND_API.G_MISS_CHAR
119: );

Line 116: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR,

112:
113: TYPE util_View_Columns_Rec_type IS RECORD
114: (
115: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
116: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
117: col_alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
118: col_name VARCHAR2(70) := FND_API.G_MISS_CHAR
119: );
120:

Line 117: col_alias VARCHAR2(70) := FND_API.G_MISS_CHAR,

113: TYPE util_View_Columns_Rec_type IS RECORD
114: (
115: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
116: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
117: col_alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
118: col_name VARCHAR2(70) := FND_API.G_MISS_CHAR
119: );
120:
121: TYPE util_View_Columns_Tbl_type IS TABLE OF util_View_Columns_Rec_type

Line 118: col_name VARCHAR2(70) := FND_API.G_MISS_CHAR

114: (
115: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
116: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
117: col_alias VARCHAR2(70) := FND_API.G_MISS_CHAR,
118: col_name VARCHAR2(70) := FND_API.G_MISS_CHAR
119: );
120:
121: TYPE util_View_Columns_Tbl_type IS TABLE OF util_View_Columns_Rec_type
122: INDEX BY BINARY_INTEGER;

Line 127: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,

123:
124:
125: TYPE util_View_From_Rec_type IS RECORD
126: (
127: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
128: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR
129: );
130:
131: TYPE util_View_From_Tbl_type IS TABLE OF util_View_From_Rec_type

Line 128: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR

124:
125: TYPE util_View_From_Rec_type IS RECORD
126: (
127: Table_Name VARCHAR2(70) := FND_API.G_MISS_CHAR,
128: Table_Alias VARCHAR2(70) := FND_API.G_MISS_CHAR
129: );
130:
131: TYPE util_View_From_Tbl_type IS TABLE OF util_View_From_Rec_type
132: INDEX BY BINARY_INTEGER;

Line 179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

175: -- End of Comments
176:
177: PROCEDURE Translate_OrderBy
178: ( p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: x_return_status OUT VARCHAR2,
182: x_msg_count OUT NUMBER,
183: x_msg_data OUT VARCHAR2,

Line 180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

176:
177: PROCEDURE Translate_OrderBy
178: ( p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: x_return_status OUT VARCHAR2,
182: x_msg_count OUT NUMBER,
183: x_msg_data OUT VARCHAR2,
184: p_order_by_tbl IN util_order_by_tbl_type,