[Home] [Help]
35: -- PURPOSE
36: -- This function checks if a foreign key is valid.
37: --
38: -- NOTES
39: -- 1. It will return FND_API.g_true/g_false.
40: -- 2. Exception encountered will be raised to the caller.
41: -- 4. Please don't put 'AND' at the beginning of your additional
42: -- where clause.
43: ---------------------------------------------------------------------
47: p_pk_value IN VARCHAR2,
48: p_pk_data_type IN NUMBER := g_number,
49: p_additional_where_clause IN VARCHAR2 := NULL
50: )
51: RETURN VARCHAR2; -- FND_API.g_true/g_false
52:
53: ---------------------------------------------------------------------
54: -- FUNCTION
55: -- is_vendor_admin_user
57: -- PURPOSE
58: -- This function checks whether the user is vendor administrator
59: --
60: -- NOTES
61: -- 1. It will return FND_API.g_true/g_false.
62: -- 2. No exception block.
63: ---------------------------------------------------------------------
64: FUNCTION is_vendor_admin_user(
65: p_resource_id IN NUMBER
63: ---------------------------------------------------------------------
64: FUNCTION is_vendor_admin_user(
65: p_resource_id IN NUMBER
66: )
67: RETURN VARCHAR2; -- FND_API.g_true/g_false
68: ---------------------------------------------------------------------
69:
70: -- FUNCTION
71: -- check_lookup_exists
77: p_lookup_table_name IN VARCHAR2 := g_pv_lookups,
78: p_lookup_type IN VARCHAR2,
79: p_lookup_code IN VARCHAR2
80: )
81: Return VARCHAR2; -- FND_API.g_true/g_false
82:
83:
84: ---------------------------------------------------------------------
85: -- FUNCTION
93: FUNCTION check_uniqueness(
94: p_table_name IN VARCHAR2,
95: p_where_clause IN VARCHAR2
96: )
97: RETURN VARCHAR2; -- FND_API.g_true/g_false
98:
99:
100: ---------------------------------------------------------------------
101: -- FUNCTION
101: -- FUNCTION
102: -- is_Y_or_N
103: --
104: -- PURPOSE
105: -- Return FND_API.g_true if p_value='Y' or p_value='N';
106: -- return FND_API.g_flase otherwise.
107: ---------------------------------------------------------------------
108: FUNCTION is_Y_or_N(
109: p_value IN VARCHAR2
102: -- is_Y_or_N
103: --
104: -- PURPOSE
105: -- Return FND_API.g_true if p_value='Y' or p_value='N';
106: -- return FND_API.g_flase otherwise.
107: ---------------------------------------------------------------------
108: FUNCTION is_Y_or_N(
109: p_value IN VARCHAR2
110: )
107: ---------------------------------------------------------------------
108: FUNCTION is_Y_or_N(
109: p_value IN VARCHAR2
110: )
111: RETURN VARCHAR2; -- FND_API.g_true/g_false
112:
113:
114: ---------------------------------------------------------------------
115: -- PROCEDURE
212: -- This procedure will take the user timezone and the input time, depending on the parameter
213: -- p_convert_type it will convert the input time to System timezone or sent Usertimezone
214: ---------------------------------------------------------------------
215: PROCEDURE Convert_Timezone(
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220:
272: p_access_level_flag IN VARCHAR2 DEFAULT 'V',
273: p_interaction_level IN NUMBER DEFAULT G_INTERACTION_LEVEL_10,
274: p_comments IN VARCHAR2 DEFAULT NULL,
275: p_log_params_tbl IN PVX_UTILITY_PVT.log_params_tbl_type,
276: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
277: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2
273: p_interaction_level IN NUMBER DEFAULT G_INTERACTION_LEVEL_10,
274: p_comments IN VARCHAR2 DEFAULT NULL,
275: p_log_params_tbl IN PVX_UTILITY_PVT.log_params_tbl_type,
276: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
277: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2
281: );