APPS.JG_ZZ_TA_CC_RANGES_PKG dependencies on JG_ZZ_TA_CC_RANGES

Line 1: PACKAGE BODY JG_ZZ_TA_CC_RANGES_PKG AS

1: PACKAGE BODY JG_ZZ_TA_CC_RANGES_PKG AS
2: /* $Header: jgzztacb.pls 115.1 2002/11/15 17:08:18 arimai ship $ */
3: --
4: -- PUBLIC FUNCTIONS
5: --

Line 11: FROM JG_ZZ_TA_CC_RANGES CCS

7: X_rule_set_id NUMBER,
8: X_cc_range_low VARCHAR2,
9: X_cc_range_high VARCHAR2 ) IS
10: CURSOR C1 IS SELECT 'Overlaps'
11: FROM JG_ZZ_TA_CC_RANGES CCS
12: WHERE RULE_SET_ID = X_rule_set_id
13: AND ((CCS.cc_range_low between
14: X_cc_range_low and X_cc_range_high)
15: OR

Line 66: FROM JG_ZZ_TA_CC_RANGES

62: ,X_attribute13 VARCHAR2
63: ,X_attribute14 VARCHAR2
64: ,X_attribute15 VARCHAR2 ) IS
65: CURSOR C IS SELECT rowid
66: FROM JG_ZZ_TA_CC_RANGES
67: WHERE CC_RANGE_ID = X_cc_range_id;
68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;
69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;
70: CURSOR C3 IS SELECT 'FOUND'

Line 68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;

64: ,X_attribute15 VARCHAR2 ) IS
65: CURSOR C IS SELECT rowid
66: FROM JG_ZZ_TA_CC_RANGES
67: WHERE CC_RANGE_ID = X_cc_range_id;
68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;
69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;
70: CURSOR C3 IS SELECT 'FOUND'
71: FROM JG_ZZ_TA_CC_RANGES
72: WHERE RULE_SET_ID = X_rule_set_id

Line 71: FROM JG_ZZ_TA_CC_RANGES

67: WHERE CC_RANGE_ID = X_cc_range_id;
68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;
69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;
70: CURSOR C3 IS SELECT 'FOUND'
71: FROM JG_ZZ_TA_CC_RANGES
72: WHERE RULE_SET_ID = X_rule_set_id
73: AND CC_RANGE_LOW = X_cc_range_low
74: AND CC_RANGE_HIGH = X_cc_range_high;
75: l_found varchar2(5);

Line 91: INSERT INTO JG_ZZ_TA_CC_RANGES

87:
88: --
89: -- Insert Row
90: --
91: INSERT INTO JG_ZZ_TA_CC_RANGES
92: (
93: rule_set_id
94: ,cc_range_id
95: ,cc_range_low

Line 190: UPDATE JG_ZZ_TA_CC_RANGES

186: BEGIN
187: --
188: -- Standard ON-UPDATE routine
189: --
190: UPDATE JG_ZZ_TA_CC_RANGES
191: SET
192: rule_set_id = X_rule_set_id
193: ,cc_range_id = X_cc_range_id /* ??????? */
194: ,cc_range_low = X_cc_range_low

Line 232: FROM JG_ZZ_TA_CC_RANGES P

228: CURSOR Get_Children(P_rowid VARCHAR2) IS
229: SELECT Row_Id
230: FROM JG_ZZ_TA_ACCOUNT_RANGES_V C
231: WHERE C.CC_RANGE_ID = (SELECT P.CC_RANGE_ID
232: FROM JG_ZZ_TA_CC_RANGES P
233: WHERE P.ROWID = P_rowid);
234: -- ITHEODOR CHANGE END
235:
236: BEGIN

Line 244: DELETE FROM JG_ZZ_TA_CC_RANGES

240: JG_ZZ_TA_ACCOUNT_RANGES_PKG.Delete_Row( Rec.Row_id );
241: END LOOP;
242: -- ITHEODOR CHANGE END
243:
244: DELETE FROM JG_ZZ_TA_CC_RANGES
245: WHERE
246: ROWID = X_rowid;
247: IF (SQL%NOTFOUND) THEN
248: RAISE NO_DATA_FOUND;

Line 281: FROM JG_ZZ_TA_CC_RANGES

277: ,X_attribute14 VARCHAR2
278: ,X_attribute15 VARCHAR2 ) IS
279: CURSOR C IS
280: SELECT *
281: FROM JG_ZZ_TA_CC_RANGES
282: WHERE rowid = X_Rowid
283: FOR UPDATE of rule_set_id NOWAIT;
284: Recinfo C%ROWTYPE;
285: BEGIN

Line 365: END JG_ZZ_TA_CC_RANGES_PKG;

361: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
362: APP_EXCEPTION.RAISE_EXCEPTION;
363: END IF;
364: END Lock_Row;
365: END JG_ZZ_TA_CC_RANGES_PKG;