APPS.IEX_API_RECORDS_PVT dependencies on JTF_PERZ_QUERY_PUB

Line 118: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,

114: p_query_desc IN VARCHAR2,
115: p_query_data_source IN VARCHAR2,
116:
117: p_query_param_tbl IN IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
118: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
119: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
120: x_query_id OUT NOCOPY NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

Line 119: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

115: p_query_data_source IN VARCHAR2,
116:
117: p_query_param_tbl IN IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
118: p_query_order_by_tbl IN Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
119: p_query_raw_sql_rec IN Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
120: x_query_id OUT NOCOPY NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2

Line 127: l_query_param_tbl JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_TBL_TYPE;

123: x_msg_data OUT NOCOPY VARCHAR2
124:
125: ) IS
126: l_profile_attrib_tbl JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE;
127: l_query_param_tbl JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_TBL_TYPE;
128:
129: BEGIN
130: FOR i IN p_query_param_tbl.FIRST..p_query_param_tbl.LAST LOOP
131:

Line 139: JTF_PERZ_QUERY_PUB.Save_Perz_Query

135: l_query_param_tbl(i).parameter_sequence := p_query_param_tbl(i).parameter_sequence;
136:
137: END LOOP;
138:
139: JTF_PERZ_QUERY_PUB.Save_Perz_Query
140: ( p_api_version_number => p_api_version_number,
141: p_init_msg_list => p_init_msg_list,
142: p_commit => p_commit,
143: p_application_id => p_application_id,

Line 182: x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,

178: x_query_desc OUT NOCOPY VARCHAR2,
179: x_query_data_source OUT NOCOPY VARCHAR2,
180:
181: x_query_param_tbl OUT NOCOPY IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
182: x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
183: x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,

Line 183: x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,

179: x_query_data_source OUT NOCOPY VARCHAR2,
180:
181: x_query_param_tbl OUT NOCOPY IEX_API_RECORDS_PVT.QUERY_PARAMETER_TBL_TYPE,
182: x_query_order_by_tbl OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_ORDER_BY_TBL_TYPE,
183: x_query_raw_sql_rec OUT NOCOPY Jtf_Perz_Query_Pub.QUERY_RAW_SQL_REC_TYPE,
184:
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2

Line 189: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE;

185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2
188: ) IS
189: l_query_param_tbl Jtf_Perz_Query_Pub.QUERY_PARAMETER_TBL_TYPE;
190: BEGIN
191: -- select all the parameters for the given query_id from jtf_perz_query_param into pl/sql table
192: JTF_PERZ_QUERY_PVT.Get_Perz_Query
193: (