APPS.JTF_PERZ_QUERY_PVT dependencies on JTF_PERZ_QUERY_PARAM

Line 36: -- 3. insert_jtf_perz_query_param

32: -- *****************************************************************************
33: -- TABLE HANDLERS
34: -- 1. insert_jtf_perz_query
35: -- 2. insert_jtf_perz_query_order_by
36: -- 3. insert_jtf_perz_query_param
37: -- 4. insert_jtf_perz_query_raw_sql
38: -- 5. update_jtf_perz_query
39:
40: -- *****************************************************************************

Line 245: PROCEDURE insert_jtf_perz_query_param(

241: END IF;
242: END insert_jtf_perz_query_raw_sql;
243: -- *****************************************************************************
244:
245: PROCEDURE insert_jtf_perz_query_param(
246: x_Rowid OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
247: X_query_param_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
248: x_Query_ID NUMBER,
249: x_Parameter_Name VARCHAR2,

Line 255: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_PARAM

251: X_Parameter_Value VARCHAR2,
252: X_Parameter_condition VARCHAR2,
253: X_Parameter_sequence VARCHAR2
254: ) IS
255: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_PARAM
256: WHERE query_param_id = X_query_param_id;
257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;
258: BEGIN
259: IF ((X_query_param_id IS NULL) OR

Line 257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;

253: X_Parameter_sequence VARCHAR2
254: ) IS
255: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_PARAM
256: WHERE query_param_id = X_query_param_id;
257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;
258: BEGIN
259: IF ((X_query_param_id IS NULL) OR
260: (X_query_param_id = Fnd_Api.G_MISS_NUM)) THEN
261: OPEN C2;

Line 265: INSERT INTO JTF_PERZ_QUERY_PARAM(

261: OPEN C2;
262: FETCH C2 INTO X_query_param_id;
263: CLOSE C2;
264: END IF;
265: INSERT INTO JTF_PERZ_QUERY_PARAM(
266: QUERY_PARAM_ID,
267: QUERY_ID,
268: PARAMETER_NAME,
269: PARAMETER_TYPE,

Line 293: END insert_jtf_perz_query_param;

289: IF (C%NOTFOUND) THEN
290: CLOSE C;
291: RAISE NO_DATA_FOUND;
292: END IF;
293: END insert_jtf_perz_query_param;
294:
295: -- ****************************************************************************
296: --******************************************************************************
297: --

Line 561: insert_jtf_perz_query_param(

557:
558: l_rowid := NULL;
559: l_query_param_id := p_query_param_tbl(l_curr_row).query_param_id;
560:
561: insert_jtf_perz_query_param(
562: l_rowid,
563: l_query_param_id,
564: l_query_id,
565: p_query_param_tbl(l_curr_row).Parameter_Name,

Line 753: DELETE FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id;

749: IF (Fnd_Api.To_Boolean(l_is_duplicate)) THEN
750:
751: -- 2. Delete all parmeter table entries for this query_id
752:
753: DELETE FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id;
754:
755: -- 3. Delete all order by table entries for this query_id
756: DELETE FROM JTF_PERZ_QUERY_ORDER_BY WHERE QUERY_ID = l_query_id;
757:

Line 796: insert_jtf_perz_query_param(

792:
793: l_rowid := NULL;
794: l_query_param_id := p_query_param_tbl(l_curr_row).query_param_id;
795:
796: insert_jtf_perz_query_param(
797: l_rowid,
798: l_query_param_id,
799: l_query_id,
800: p_query_param_tbl(l_curr_row).Parameter_Name,

Line 929: DELETE FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id;

925: -- dbms_output.put_line('id from databe ' || l_query_id);
926:
927: -- 2. Delete all parmeter table entries for this query_id
928:
929: DELETE FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id;
930:
931: -- 3. Delete all order by table entries for this query_id
932: DELETE FROM JTF_PERZ_QUERY_ORDER_BY WHERE QUERY_ID = l_query_id;
933:

Line 1356: FROM JTF_PERZ_QUERY_PARAM

1352: CURSOR C_Get_Query_param (p_query_id NUMBER) IS
1353: SELECT QUERY_PARAM_ID, QUERY_ID, PARAMETER_NAME,
1354: PARAMETER_TYPE, PARAMETER_VALUE, PARAMETER_CONDITION,
1355: PARAMETER_SEQUENCE
1356: FROM JTF_PERZ_QUERY_PARAM
1357: WHERE QUERY_ID = p_query_id
1358: ORDER BY PARAMETER_SEQUENCE;
1359:
1360: CURSOR C_Get_Query_Order_By (p_query_id NUMBER) IS