APPS.JTF_PERZ_QUERY_PVT dependencies on JTF_PERZ_QUERY_ORDER_BY

Line 35: -- 2. insert_jtf_perz_query_order_by

31: -- *****************************************************************************
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:

Line 141: PROCEDURE insert_jtf_perz_query_order_by(

137: -- *****************************************************************************
138:
139: -- insert row into query header
140:
141: PROCEDURE insert_jtf_perz_query_order_by(
142: X_ROWID OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
143: X_QUERY_ORDER_BY_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
144: X_QUERY_ID NUMBER,
145: X_PARAMETER_NAME VARCHAR2,

Line 149: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_ORDER_BY

145: X_PARAMETER_NAME VARCHAR2,
146: X_ACND_DCND_FLAG VARCHAR2,
147: X_PARAMETER_SEQUENCE NUMBER
148: ) IS
149: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_ORDER_BY
150: WHERE QUERY_ORDER_BY_ID = x_QUERY_ORDER_BY_ID;
151:
152: CURSOR C2 IS SELECT JTF_PERZ_QUERY_ORDER_BY_s.NEXTVAL FROM sys.dual;
153:

Line 152: CURSOR C2 IS SELECT JTF_PERZ_QUERY_ORDER_BY_s.NEXTVAL FROM sys.dual;

148: ) IS
149: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_ORDER_BY
150: WHERE QUERY_ORDER_BY_ID = x_QUERY_ORDER_BY_ID;
151:
152: CURSOR C2 IS SELECT JTF_PERZ_QUERY_ORDER_BY_s.NEXTVAL FROM sys.dual;
153:
154: BEGIN
155: IF (x_QUERY_ORDER_BY_ID IS NULL) THEN
156: OPEN C2;

Line 160: INSERT INTO JTF_PERZ_QUERY_ORDER_BY(

156: OPEN C2;
157: FETCH C2 INTO x_QUERY_ORDER_BY_ID;
158: CLOSE C2;
159: END IF;
160: INSERT INTO JTF_PERZ_QUERY_ORDER_BY(
161: QUERY_ORDER_BY_ID,
162: QUERY_ID,
163: PARAMETER_NAME,
164: ACND_DCND_FLAG,

Line 184: END insert_jtf_perz_query_order_by;

180: IF (C%NOTFOUND) THEN
181: CLOSE C;
182: RAISE NO_DATA_FOUND;
183: END IF;
184: END insert_jtf_perz_query_order_by;
185:
186: -- *****************************************************************************
187:
188: -- insert row into query order by

Line 539: insert_jtf_perz_query_order_by(

535:
536: l_rowid := NULL;
537: l_query_order_by_id :=p_query_order_by_tbl(l_curr_row).query_order_by_id ;
538:
539: insert_jtf_perz_query_order_by(
540: l_rowid,
541: l_query_Order_By_ID,
542: l_query_id,
543: p_query_order_by_tbl(l_curr_row).Parameter_Name,

Line 756: DELETE FROM JTF_PERZ_QUERY_ORDER_BY WHERE QUERY_ID = l_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:
758: -- 4. Delete all raw sql table entries for this query_id
759: DELETE FROM JTF_PERZ_QUERY_RAW_SQL WHERE QUERY_ID = l_query_id;
760:

Line 781: insert_jtf_perz_query_order_by(l_rowid,

777:
778: l_rowid := NULL;
779: l_Query_Order_By_ID := p_query_order_by_tbl(l_curr_row).Query_Order_By_ID;
780:
781: insert_jtf_perz_query_order_by(l_rowid,
782: l_Query_Order_By_ID,
783: l_query_id,
784: p_query_order_by_tbl(l_curr_row).Parameter_Name,
785: p_query_order_by_tbl(l_curr_row).Acnd_Dcnd_Flag,

Line 932: DELETE FROM JTF_PERZ_QUERY_ORDER_BY WHERE QUERY_ID = l_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:
934: -- 4. Delete all raw sql table entries for this query_id
935: DELETE FROM JTF_PERZ_QUERY_RAW_SQL WHERE QUERY_ID = l_query_id;
936:

Line 1363: FROM JTF_PERZ_QUERY_ORDER_BY

1359:
1360: CURSOR C_Get_Query_Order_By (p_query_id NUMBER) IS
1361: SELECT QUERY_ORDER_BY_ID, QUERY_ID, PARAMETER_NAME,
1362: ACND_DCND_FLAG, PARAMETER_SEQUENCE
1363: FROM JTF_PERZ_QUERY_ORDER_BY
1364: WHERE QUERY_ID = p_query_id
1365: ORDER BY PARAMETER_SEQUENCE;
1366: BEGIN
1367: -- ******* Standard Begins ********