APPS.OZF_DENORM_QUERIES_PVT dependencies on OZF_DENORM_QUERIES

Line 1: PACKAGE BODY Ozf_Denorm_Queries_Pvt AS

1: PACKAGE BODY Ozf_Denorm_Queries_Pvt AS
2: /*$Header: ozfvofdb.pls 120.0 2005/06/01 02:39:55 appldev noship $*/
3:
4:
5:

Line 41: SELECT ozf_denorm_queries_s.NEXTVAL

37: l_string varchar2(32000):= l_denorm_queries_rec.SQL_STATEMENT;
38: l_denorm_count NUMBER;
39:
40: CURSOR c_denorm_queries_seq IS
41: SELECT ozf_denorm_queries_s.NEXTVAL
42: FROM DUAL;
43:
44:
45: CURSOR c_denorm_count(denorm_id IN NUMBER) IS

Line 47: FROM ozf_denorm_queries

43:
44:
45: CURSOR c_denorm_count(denorm_id IN NUMBER) IS
46: SELECT count(*)
47: FROM ozf_denorm_queries
48: WHERE denorm_query_id = denorm_id;
49: BEGIN
50:
51: --------------------- initialize -----------------------

Line 114: INSERT INTO ozf_denorm_queries(

110: --dbms_output.put_line('the denorm condition id IS'||l_denorm_queries_rec.condition_id_column);
111: string_length_check(l_string,l_stringArray);
112: --dbms_output.put_line('before insert'||SUBSTR(l_stringArray(1),1,150));
113: --dbms_output.put_line('before insert for sec'||SUBSTR(l_stringArray(2),1,150));
114: INSERT INTO ozf_denorm_queries(
115: DENORM_QUERY_ID
116: ,QUERY_FOR
117: ,CONTEXT
118: ,ATTRIBUTE

Line 307: UPDATE ozf_denorm_queries SET

303: string_length_check(temp_denorm_queries_rec.SQL_STATEMENT,l_stringArray);
304:
305:
306:
307: UPDATE ozf_denorm_queries SET
308: last_update_date = SYSDATE,
309: last_updated_by = FND_GLOBAL.user_id,
310: last_update_login = FND_GLOBAL.conc_login_id,
311: active_flag = nvl(temp_denorm_queries_rec.active_flag,'N'),

Line 446: delete ozf_denorm_queries

442:
443: ------------------------ delete ------------------------
444: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
445:
446: delete ozf_denorm_queries
447: WHERE denorm_query_id = p_denorm_query_id
448: AND OBJECT_VERSION_NUMBER=p_object_version;
449:
450: -------------------- finish --------------------------

Line 633: select denorm_query_id from ozf_denorm_queries

629: temp_context_attribute varchar2(30);
630: l_denorm_queries_rec denorm_queries_rec_type;
631: l_denorm_query_id NUMBER;
632: CURSOR chkexists(p_query_for IN varchar2,p_context_name IN varchar2,p_context_attribute IN varchar2) IS
633: select denorm_query_id from ozf_denorm_queries
634: where query_for=p_query_for and context=p_context_name
635: and attribute=p_context_attribute;
636: BEGIN
637: /*

Line 647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');

643: ELSE
644: IF(l_denorm_query_id<>p_denorm_queries_rec.denorm_query_id)THEN
645: OZF_Utility_PVT.debug_message('This record already exists');
646: x_return_status:='E';
647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
648: FND_MSG_PUB.add;
649: END IF;
650: END IF;
651: */

Line 851: select query_for,context,attribute from ozf_denorm_queries

847: temp_context_attribute varchar2(30);
848: l_denorm_queries_rec denorm_queries_rec_type;
849:
850: CURSOR chkexists(p_query_for IN varchar2,p_context_name IN varchar2,p_context_attribute IN varchar2) IS
851: select query_for,context,attribute from ozf_denorm_queries
852: where query_for=p_query_for and context=p_context_name
853: and attribute=p_context_attribute;
854: BEGIN
855: /*

Line 864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');

860: X_RETURN_STATUS:='S';
861: ELSE
862: OZF_Utility_PVT.debug_message('This record already exists');
863: x_return_status:='E';
864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
865: FND_MSG_PUB.add;
866: END IF;
867: */
868: NULL;

Line 904: FROM ozf_denorm_queries

900: IS
901:
902: CURSOR c_denorm_queries IS
903: SELECT *
904: FROM ozf_denorm_queries
905: WHERE denorm_query_id = p_denorm_queries_rec.denorm_query_id;
906:
907:
908: l_denorm_queries_rec c_denorm_queries%ROWTYPE;

Line 1055: END Ozf_Denorm_Queries_Pvt;

1051:
1052: END string_length_check;
1053:
1054:
1055: END Ozf_Denorm_Queries_Pvt;