APPS.HZ_DSS_GROUPS_PKG dependencies on HZ_DSS_GROUPS_B

Line 21: INSERT INTO HZ_DSS_GROUPS_B (

17: BEGIN
18:
19: WHILE l_success = 'N' LOOP
20: BEGIN
21: INSERT INTO HZ_DSS_GROUPS_B (
22: dss_group_code,
23: rank,
24: status,
25: last_update_date,

Line 114: UPDATE HZ_DSS_GROUPS_B

110: ) IS
111: l_dss_group_code varchar2(30);
112: BEGIN
113:
114: UPDATE HZ_DSS_GROUPS_B
115: SET
116: rank =
117: DECODE(x_rank,
118: NULL, rank,

Line 192: SELECT * FROM hz_dss_groups_b

188: x_object_version_number IN NUMBER
189: ) IS
190:
191: CURSOR c IS
192: SELECT * FROM hz_dss_groups_b
193: WHERE rowid = x_rowid
194: FOR UPDATE NOWAIT;
195: Recinfo c%ROWTYPE;
196:

Line 273: FROM HZ_DSS_GROUPS_B

269: x_rank,
270: x_status,
271: x_bes_enable_flag,
272: x_object_version_number
273: FROM HZ_DSS_GROUPS_B
274: WHERE dss_group_code = x_dss_group_code;
275:
276:
277: SELECT

Line 302: DELETE FROM HZ_DSS_GROUPS_B

298: x_dss_group_code IN VARCHAR2
299: ) IS
300: BEGIN
301:
302: DELETE FROM HZ_DSS_GROUPS_B
303: WHERE dss_group_code = x_dss_group_code;
304:
305: IF ( SQL%NOTFOUND ) THEN
306: RAISE NO_DATA_FOUND;

Line 326: from HZ_DSS_GROUPS_B B

322: begin
323: delete from HZ_DSS_GROUPS_TL T
324: where not exists
325: (select NULL
326: from HZ_DSS_GROUPS_B B
327: where B.DSS_GROUP_CODE = T.DSS_GROUP_CODE
328: );
329:
330: update HZ_DSS_GROUPS_TL T set (

Line 421: from HZ_DSS_GROUPS_B

417:
418: begin
419: select LAST_UPDATED_BY, LAST_UPDATE_DATE
420: into l_db_luby, l_db_ludate
421: from HZ_DSS_GROUPS_B
422: where DSS_GROUP_CODE = x_dss_group_code;
423:
424: -- Update record, honoring customization mode.
425: -- Record should be updated only if: