APPS.AMS_ADV_FILTER_PKG dependencies on JTF_PERZ_QUERY_PARAM

Line 25: -- PURPOSE To create a Database record in JTF_PERZ_QUERY_PARAM table.

21: --
22: -- NAME
23: -- createInsertBody
24: --
25: -- PURPOSE To create a Database record in JTF_PERZ_QUERY_PARAM table.
26: --
27: -- NOTES
28: --
29: -- HISTORY

Line 54: INSERT INTO JTF_PERZ_QUERY_PARAM

50:
51: BEGIN
52:
53:
54: INSERT INTO JTF_PERZ_QUERY_PARAM
55: (
56: query_param_id,
57: query_id,
58: parameter_name,

Line 92: -- PURPOSE Update the Record in JTF_PERZ_QUERY_PARAM table.

88: --
89: -- NAME
90: -- create UpdateBody
91: --
92: -- PURPOSE Update the Record in JTF_PERZ_QUERY_PARAM table.
93: --
94: -- NOTES
95: --
96: -- HISTORY

Line 117: Update JTF_PERZ_QUERY_PARAM

113: l_flag VARCHAR2(4);
114: BEGIN
115: AMS_UTILITY_PVT.debug_message('Table Handler API: Update_row');
116:
117: Update JTF_PERZ_QUERY_PARAM
118: SET
119: parameter_name = DECODE( p_parameter_name, FND_API.g_miss_char, parameter_name, p_parameter_name),
120: parameter_value = DECODE( p_parameter_value, FND_API.g_miss_char, parameter_value, p_parameter_value),
121: parameter_condition = DECODE( p_parameter_condition, FND_API.g_miss_char, parameter_condition, p_parameter_condition),

Line 147: -- PURPOSE Delete a Row from JTF_PERZ_QUERY_PARAM Table.

143: --
144: -- NAME
145: -- createDeleteBody
146: --
147: -- PURPOSE Delete a Row from JTF_PERZ_QUERY_PARAM Table.
148: --
149: -- NOTES
150: --
151: -- HISTORY

Line 158: DELETE FROM JTF_PERZ_QUERY_PARAM

154: PROCEDURE Delete_Row(
155: p_query_param_id NUMBER)
156: IS
157: BEGIN
158: DELETE FROM JTF_PERZ_QUERY_PARAM
159: WHERE query_param_id = p_query_param_id;
160: If (SQL%NOTFOUND) then
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: End If;