APPS.OZF_FUNDTHRESHOLDS_ALL_B_PKG dependencies on OZF_THRESHOLDS_ALL_B

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_THRESHOLDS_ALL_B_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_THRESHOLDS_ALL_B_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftthrb.pls';
19:
20:
21: ----------------------------------------------------------

Line 91: INSERT INTO OZF_THRESHOLDS_ALL_B(

87:
88: px_object_version_number := 1;
89:
90:
91: INSERT INTO OZF_THRESHOLDS_ALL_B(
92: threshold_id,
93: last_update_date,
94: last_updated_by,
95: last_update_login,

Line 315: Update OZF_THRESHOLDS_ALL_B

311: p_threshold_type VARCHAR2)
312:
313: IS
314: BEGIN
315: Update OZF_THRESHOLDS_ALL_B
316: SET
317: threshold_id = p_threshold_id,
318: last_update_date = p_last_update_date,
319: last_updated_by = p_last_updated_by,

Line 409: DELETE FROM OZF_THRESHOLDS_ALL_B

405: PROCEDURE Delete_Row(
406: p_THRESHOLD_ID NUMBER)
407: IS
408: BEGIN
409: DELETE FROM OZF_THRESHOLDS_ALL_B
410: WHERE THRESHOLD_ID = p_THRESHOLD_ID;
411:
412: DELETE FROM OZF_THRESHOLDS_ALL_TL
413: WHERE THRESHOLD_ID = p_THRESHOLD_ID;

Line 480: FROM OZF_THRESHOLDS_ALL_B

476:
477: IS
478: CURSOR C IS
479: SELECT *
480: FROM OZF_THRESHOLDS_ALL_B
481: WHERE THRESHOLD_ID = p_THRESHOLD_ID
482: FOR UPDATE of THRESHOLD_ID NOWAIT;
483: Recinfo C%ROWTYPE;
484: BEGIN

Line 614: from OZF_THRESHOLDS_ALL_B B

610: begin
611: delete from OZF_THRESHOLDS_ALL_TL T
612: where not exists
613: (select NULL
614: from OZF_THRESHOLDS_ALL_B B
615: where B.THRESHOLD_ID = T.THRESHOLD_ID
616: );
617:
618: update OZF_THRESHOLDS_ALL_TL T set (