[Home] [Help]
192: -- PURPOSE
193: -- This function checks if a foreign key is valid.
194: --
195: -- NOTES
196: -- 1. It will return FND_API.g_true/g_false.
197: -- 2. Exception encountered will be raised to the caller.
198: -- 3. p_pk_data_type can be OZF_Global_PVT.g_number/g_varchar2.
199: -- 4. Please don't put 'AND' at the beginning of your additional
200: -- where clause.
205: p_pk_value IN VARCHAR2,
206: p_pk_data_type IN NUMBER := g_number,
207: p_additional_where_clause IN VARCHAR2 := NULL
208: )
209: RETURN VARCHAR2; -- FND_API.g_true/g_false
210:
211:
212: ---------------------------------------------------------------------
213: -- FUNCTION
221: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,
222: p_lookup_type IN VARCHAR2,
223: p_lookup_code IN VARCHAR2
224: )
225: Return VARCHAR2; -- FND_API.g_true/g_false
226:
227: ---------------------------------------------------------------------
228: -- FUNCTION
229: -- check_lookup_exists
236: p_lookup_type IN VARCHAR2,
237: p_lookup_code IN VARCHAR2,
238: p_view_application_id IN NUMBER
239: )
240: Return VARCHAR2; -- FND_API.g_true/g_false
241:
242:
243: ---------------------------------------------------------------------
244: -- FUNCTION
252: FUNCTION check_uniqueness(
253: p_table_name IN VARCHAR2,
254: p_where_clause IN VARCHAR2
255: )
256: RETURN VARCHAR2; -- FND_API.g_true/g_false
257:
258:
259: ---------------------------------------------------------------------
260: -- FUNCTION
260: -- FUNCTION
261: -- is_Y_or_N
262: --
263: -- PURPOSE
264: -- Return FND_API.g_true if p_value='Y' or p_value='N';
265: -- return FND_API.g_flase otherwise.
266: ---------------------------------------------------------------------
267: FUNCTION is_Y_or_N(
268: p_value IN VARCHAR2
261: -- is_Y_or_N
262: --
263: -- PURPOSE
264: -- Return FND_API.g_true if p_value='Y' or p_value='N';
265: -- return FND_API.g_flase otherwise.
266: ---------------------------------------------------------------------
267: FUNCTION is_Y_or_N(
268: p_value IN VARCHAR2
269: )
266: ---------------------------------------------------------------------
267: FUNCTION is_Y_or_N(
268: p_value IN VARCHAR2
269: )
270: RETURN VARCHAR2; -- FND_API.g_true/g_false
271:
272:
273: ---------------------------------------------------------------------
274: -- PROCEDURE
454: -- converted to user timezone sent.
455: -- 06-sep-2001 choang set default for p_user_tz_id for bug 1857131.
456: ---------------------------------------------------------------------
457: PROCEDURE Convert_Timezone(
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,
462:
813: ---------------------------------------------------------------------
814: PROCEDURE convert_currency(
815: p_from_currency IN VARCHAR2
816: ,p_to_currency IN VARCHAR2
817: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
818: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
819: ,p_conv_date IN DATE DEFAULT SYSDATE
820: ,p_from_amount IN NUMBER
821: ,x_return_status OUT NOCOPY VARCHAR2
814: PROCEDURE convert_currency(
815: p_from_currency IN VARCHAR2
816: ,p_to_currency IN VARCHAR2
817: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
818: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
819: ,p_conv_date IN DATE DEFAULT SYSDATE
820: ,p_from_amount IN NUMBER
821: ,x_return_status OUT NOCOPY VARCHAR2
822: ,x_to_amount OUT NOCOPY NUMBER
892: -- Check_Status_Change
893: --
894: -- PURPOSE
895: -- Created to check if the status change is valid or not.
896: -- Returns FND_API.G_TRUE if it is valid status change
897: -- or will return FND_API.G_FALSE
898: --
899: -- HISTORY
900: -- 09-Jul-2001 ptendulk Create.
893: --
894: -- PURPOSE
895: -- Created to check if the status change is valid or not.
896: -- Returns FND_API.G_TRUE if it is valid status change
897: -- or will return FND_API.G_FALSE
898: --
899: -- HISTORY
900: -- 09-Jul-2001 ptendulk Create.
901: --======================================================================
1101: -- FUNCTION
1102: -- Has_Sales_Rep_Role
1103: --
1104: -- PURPOSE
1105: -- This api returns FND_API.g_true if the given user has the "Sales
1106: -- Representative" role. It returns FND_API.g_false otherwise.
1107: --
1108: -- HISTORY
1109: -- 23-Feb-2004 yizhang Create.
1102: -- Has_Sales_Rep_Role
1103: --
1104: -- PURPOSE
1105: -- This api returns FND_API.g_true if the given user has the "Sales
1106: -- Representative" role. It returns FND_API.g_false otherwise.
1107: --
1108: -- HISTORY
1109: -- 23-Feb-2004 yizhang Create.
1110: --======================================================================
1238: ---------------------------------------------------------------------
1239: FUNCTION convert_currency(
1240: p_from_currency IN VARCHAR2
1241: ,p_to_currency IN VARCHAR2
1242: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1243: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
1244: ,p_conv_date IN DATE DEFAULT SYSDATE
1245: ,p_from_amount IN NUMBER
1246: )
1239: FUNCTION convert_currency(
1240: p_from_currency IN VARCHAR2
1241: ,p_to_currency IN VARCHAR2
1242: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1243: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
1244: ,p_conv_date IN DATE DEFAULT SYSDATE
1245: ,p_from_amount IN NUMBER
1246: )
1247: RETURN NUMBER;