DBA Data[Home] [Help]

APPS.AMW_UTILITY_PVT dependencies on FND_API

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

39: -- PURPOSE
40: -- This function checks if a foreign key is valid.
41: --
42: -- NOTES
43: -- 1. It will return FND_API.g_true/g_false.
44: -- 2. Exception encountered will be raised to the caller.
45: -- 3. p_pk_data_type can be AMW_Global_PVT.g_number/g_varchar2.
46: -- 4. Please don't put 'AND' at the beginning of your additional
47: -- where clause.

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

52: p_pk_value IN VARCHAR2,
53: p_pk_data_type IN NUMBER := g_number,
54: p_additional_where_clause IN VARCHAR2 := NULL
55: )
56: RETURN VARCHAR2; -- FND_API.g_true/g_false
57:
58:
59: ---------------------------------------------------------------------
60: -- FUNCTION

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

68: p_lookup_table_name IN VARCHAR2 := g_amw_lookups,
69: p_lookup_type IN VARCHAR2,
70: p_lookup_code IN VARCHAR2
71: )
72: Return VARCHAR2; -- FND_API.g_true/g_false
73:
74: ---------------------------------------------------------------------
75: -- FUNCTION
76: -- check_lookup_exists

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

83: p_lookup_type IN VARCHAR2,
84: p_lookup_code IN VARCHAR2,
85: p_view_application_id IN NUMBER
86: )
87: Return VARCHAR2; -- FND_API.g_true/g_false
88:
89:
90: ---------------------------------------------------------------------
91: -- FUNCTION

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

99: FUNCTION check_uniqueness(
100: p_table_name IN VARCHAR2,
101: p_where_clause IN VARCHAR2
102: )
103: RETURN VARCHAR2; -- FND_API.g_true/g_false
104:
105:
106: ---------------------------------------------------------------------
107: -- FUNCTION

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

107: -- FUNCTION
108: -- is_Y_or_N
109: --
110: -- PURPOSE
111: -- Return FND_API.g_true if p_value='Y' or p_value='N';
112: -- return FND_API.g_flase otherwise.
113: ---------------------------------------------------------------------
114: FUNCTION is_Y_or_N(
115: p_value IN VARCHAR2

Line 112: -- return FND_API.g_flase otherwise.

108: -- is_Y_or_N
109: --
110: -- PURPOSE
111: -- Return FND_API.g_true if p_value='Y' or p_value='N';
112: -- return FND_API.g_flase otherwise.
113: ---------------------------------------------------------------------
114: FUNCTION is_Y_or_N(
115: p_value IN VARCHAR2
116: )

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

113: ---------------------------------------------------------------------
114: FUNCTION is_Y_or_N(
115: p_value IN VARCHAR2
116: )
117: RETURN VARCHAR2; -- FND_API.g_true/g_false
118:
119:
120: ---------------------------------------------------------------------
121: -- FUNCTION

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

259: p_status OUT nocopy varchar2,
260: p_dev_phase OUT nocopy varchar2,
261: p_dev_status OUT nocopy varchar2,
262: p_message OUT nocopy varchar2,
263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264: x_return_status out nocopy varchar2,
265: x_msg_count out nocopy number,
266: x_msg_data out nocopy varchar2
267: );

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

340: p_pk IN number,
341: p_userid IN number,
342: p_objectContext IN varchar2,
343: p_retval OUT nocopy varchar2,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: x_return_status out nocopy varchar2,
346: x_msg_count out nocopy number,
347: x_msg_data out nocopy varchar2
348: );