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.

APPS.OZF_UTILITY_PVT dependencies on FND_API

Line 126: -- 1. It will return FND_API.g_true/g_false.

122: -- PURPOSE
123: -- This function checks if a foreign key is valid.
124: --
125: -- NOTES
126: -- 1. It will return FND_API.g_true/g_false.
127: -- 2. Exception encountered will be raised to the caller.
128: -- 3. p_pk_data_type can be OZF_Global_PVT.g_number/g_varchar2.
129: -- 4. Please don't put 'AND' at the beginning of your additional
130: -- where clause.

Line 139: RETURN VARCHAR2; -- FND_API.g_true/g_false

135: p_pk_value IN VARCHAR2,
136: p_pk_data_type IN NUMBER := g_number,
137: p_additional_where_clause IN VARCHAR2 := NULL
138: )
139: RETURN VARCHAR2; -- FND_API.g_true/g_false
140:
141:
142: ---------------------------------------------------------------------
143: -- FUNCTION

Line 155: Return VARCHAR2; -- FND_API.g_true/g_false

151: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,
152: p_lookup_type IN VARCHAR2,
153: p_lookup_code IN VARCHAR2
154: )
155: Return VARCHAR2; -- FND_API.g_true/g_false
156:
157: ---------------------------------------------------------------------
158: -- FUNCTION
159: -- check_lookup_exists

Line 170: Return VARCHAR2; -- FND_API.g_true/g_false

166: p_lookup_type IN VARCHAR2,
167: p_lookup_code IN VARCHAR2,
168: p_view_application_id IN NUMBER
169: )
170: Return VARCHAR2; -- FND_API.g_true/g_false
171:
172:
173: ---------------------------------------------------------------------
174: -- FUNCTION

Line 186: RETURN VARCHAR2; -- FND_API.g_true/g_false

182: FUNCTION check_uniqueness(
183: p_table_name IN VARCHAR2,
184: p_where_clause IN VARCHAR2
185: )
186: RETURN VARCHAR2; -- FND_API.g_true/g_false
187:
188:
189: ---------------------------------------------------------------------
190: -- FUNCTION

Line 194: -- Return FND_API.g_true if p_value='Y' or p_value='N';

190: -- FUNCTION
191: -- is_Y_or_N
192: --
193: -- PURPOSE
194: -- Return FND_API.g_true if p_value='Y' or p_value='N';
195: -- return FND_API.g_flase otherwise.
196: ---------------------------------------------------------------------
197: FUNCTION is_Y_or_N(
198: p_value IN VARCHAR2

Line 195: -- return FND_API.g_flase otherwise.

191: -- is_Y_or_N
192: --
193: -- PURPOSE
194: -- Return FND_API.g_true if p_value='Y' or p_value='N';
195: -- return FND_API.g_flase otherwise.
196: ---------------------------------------------------------------------
197: FUNCTION is_Y_or_N(
198: p_value IN VARCHAR2
199: )

Line 200: RETURN VARCHAR2; -- FND_API.g_true/g_false

196: ---------------------------------------------------------------------
197: FUNCTION is_Y_or_N(
198: p_value IN VARCHAR2
199: )
200: RETURN VARCHAR2; -- FND_API.g_true/g_false
201:
202:
203: ---------------------------------------------------------------------
204: -- PROCEDURE

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

384: -- converted to user timezone sent.
385: -- 06-sep-2001 choang set default for p_user_tz_id for bug 1857131.
386: ---------------------------------------------------------------------
387: PROCEDURE Convert_Timezone(
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
392:

Line 747: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

743: ---------------------------------------------------------------------
744: PROCEDURE convert_currency(
745: p_from_currency IN VARCHAR2
746: ,p_to_currency IN VARCHAR2
747: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
748: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
749: ,p_conv_date IN DATE DEFAULT SYSDATE
750: ,p_from_amount IN NUMBER
751: ,x_return_status OUT NOCOPY VARCHAR2

Line 748: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM

744: PROCEDURE convert_currency(
745: p_from_currency IN VARCHAR2
746: ,p_to_currency IN VARCHAR2
747: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
748: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
749: ,p_conv_date IN DATE DEFAULT SYSDATE
750: ,p_from_amount IN NUMBER
751: ,x_return_status OUT NOCOPY VARCHAR2
752: ,x_to_amount OUT NOCOPY NUMBER

Line 826: -- Returns FND_API.G_TRUE if it is valid status change

822: -- Check_Status_Change
823: --
824: -- PURPOSE
825: -- Created to check if the status change is valid or not.
826: -- Returns FND_API.G_TRUE if it is valid status change
827: -- or will return FND_API.G_FALSE
828: --
829: -- HISTORY
830: -- 09-Jul-2001 ptendulk Create.

Line 827: -- or will return FND_API.G_FALSE

823: --
824: -- PURPOSE
825: -- Created to check if the status change is valid or not.
826: -- Returns FND_API.G_TRUE if it is valid status change
827: -- or will return FND_API.G_FALSE
828: --
829: -- HISTORY
830: -- 09-Jul-2001 ptendulk Create.
831: --======================================================================

Line 1035: -- This api returns FND_API.g_true if the given user has the "Sales

1031: -- FUNCTION
1032: -- Has_Sales_Rep_Role
1033: --
1034: -- PURPOSE
1035: -- This api returns FND_API.g_true if the given user has the "Sales
1036: -- Representative" role. It returns FND_API.g_false otherwise.
1037: --
1038: -- HISTORY
1039: -- 23-Feb-2004 yizhang Create.

Line 1036: -- Representative" role. It returns FND_API.g_false otherwise.

1032: -- Has_Sales_Rep_Role
1033: --
1034: -- PURPOSE
1035: -- This api returns FND_API.g_true if the given user has the "Sales
1036: -- Representative" role. It returns FND_API.g_false otherwise.
1037: --
1038: -- HISTORY
1039: -- 23-Feb-2004 yizhang Create.
1040: --======================================================================