APPS.HZ_DSS_CRITERIA_PKG dependencies on HZ_DSS_CRITERIA

Line 1: PACKAGE BODY HZ_DSS_CRITERIA_PKG AS

1: PACKAGE BODY HZ_DSS_CRITERIA_PKG AS
2: /* $Header: ARHPDSCB.pls 115.2 2002/10/10 01:42:09 chsaulit noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 24: INSERT INTO HZ_DSS_CRITERIA (

20: BEGIN
21:
22: WHILE l_success = 'N' LOOP
23: BEGIN
24: INSERT INTO HZ_DSS_CRITERIA (
25: secured_item_id,
26: status,
27: dss_group_code,
28: owner_table_name,

Line 43: FND_API.G_MISS_NUM, HZ_DSS_CRITERIA_S.NEXTVAL,

39: object_version_number
40: )
41: VALUES (
42: DECODE(x_secured_item_id,
43: FND_API.G_MISS_NUM, HZ_DSS_CRITERIA_S.NEXTVAL,
44: NULL, HZ_DSS_CRITERIA_S.NEXTVAL,
45: x_secured_item_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',

Line 44: NULL, HZ_DSS_CRITERIA_S.NEXTVAL,

40: )
41: VALUES (
42: DECODE(x_secured_item_id,
43: FND_API.G_MISS_NUM, HZ_DSS_CRITERIA_S.NEXTVAL,
44: NULL, HZ_DSS_CRITERIA_S.NEXTVAL,
45: x_secured_item_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',
48: NULL, 'A',

Line 90: IF INSTR(SQLERRM, 'HZ_DSS_CRITERIA_U1') <> 0 THEN

86: l_success := 'Y';
87:
88: EXCEPTION
89: WHEN DUP_VAL_ON_INDEX THEN
90: IF INSTR(SQLERRM, 'HZ_DSS_CRITERIA_U1') <> 0 THEN
91: DECLARE
92: l_count NUMBER;
93: l_dummy VARCHAR2(1);
94: BEGIN

Line 97: SELECT HZ_DSS_CRITERIA_S.NEXTVAL

93: l_dummy VARCHAR2(1);
94: BEGIN
95: l_count := 1;
96: WHILE l_count > 0 LOOP
97: SELECT HZ_DSS_CRITERIA_S.NEXTVAL
98: INTO x_secured_item_id FROM dual;
99: BEGIN
100: SELECT 'Y' INTO l_dummy
101: FROM HZ_DSS_CRITERIA

Line 101: FROM HZ_DSS_CRITERIA

97: SELECT HZ_DSS_CRITERIA_S.NEXTVAL
98: INTO x_secured_item_id FROM dual;
99: BEGIN
100: SELECT 'Y' INTO l_dummy
101: FROM HZ_DSS_CRITERIA
102: WHERE secured_item_id = x_secured_item_id;
103: l_count := 1;
104: EXCEPTION
105: WHEN NO_DATA_FOUND THEN

Line 131: UPDATE HZ_DSS_CRITERIA

127: x_object_version_number IN NUMBER
128: ) IS
129: BEGIN
130:
131: UPDATE HZ_DSS_CRITERIA
132: SET
133: status =
134: DECODE(x_status,
135: NULL, status,

Line 213: SELECT * FROM hz_dss_criteria

209: x_object_version_number IN NUMBER
210: ) IS
211:
212: CURSOR c IS
213: SELECT * FROM hz_dss_criteria
214: WHERE rowid = x_rowid
215: FOR UPDATE NOWAIT;
216: Recinfo c%ROWTYPE;
217:

Line 322: FROM HZ_DSS_CRITERIA

318: x_owner_table_id3,
319: x_owner_table_id4,
320: x_owner_table_id5,
321: x_object_version_number
322: FROM HZ_DSS_CRITERIA
323: WHERE secured_item_id = x_secured_item_id;
324:
325: EXCEPTION
326: WHEN NO_DATA_FOUND THEN

Line 340: DELETE FROM HZ_DSS_CRITERIA

336: x_secured_item_id IN NUMBER
337: ) IS
338: BEGIN
339:
340: DELETE FROM HZ_DSS_CRITERIA
341: WHERE secured_item_id = x_secured_item_id;
342:
343: IF ( SQL%NOTFOUND ) THEN
344: RAISE NO_DATA_FOUND;

Line 349: END HZ_DSS_CRITERIA_PKG;

345: END IF;
346:
347: END Delete_Row;
348:
349: END HZ_DSS_CRITERIA_PKG;