APPS.DDR_EMD_UTIL dependencies on DDR_B_EXCPTN_ITEM_DAY

Line 37: INSERT INTO DDR_B_EXCPTN_ITEM_DAY

33: , p_user_id IN VARCHAR2
34: , p_excptn_qty IN VARCHAR2 DEFAULT NULL
35: , p_excptn_amt IN VARCHAR2 DEFAULT NULL) IS
36: BEGIN
37: INSERT INTO DDR_B_EXCPTN_ITEM_DAY
38: (MFG_ORG_CD,
39: RTL_ORG_CD,
40: ORG_BSNS_UNIT_ID,
41: DAY_CD,

Line 81: DELETE FROM DDR_B_EXCPTN_ITEM_DAY

77: PROCEDURE delete_exception(p_excptn_type IN VARCHAR2
78: , p_excptn_src_code IN VARCHAR2
79: , p_date_offset IN NUMBER DEFAULT 0) IS
80: BEGIN
81: DELETE FROM DDR_B_EXCPTN_ITEM_DAY
82: WHERE EXCPTN_TYP = p_excptn_type
83: AND EXCPTN_SRC_CD = p_excptn_src_code
84: AND DAY_CD >= to_char(SYSDATE - p_date_offset, 'YYYYMMDD');
85:

Line 99: DELETE FROM ddr_b_excptn_item_day

95: ) IS
96: BEGIN
97: x_return_status := ddr_emd_util.success;
98:
99: DELETE FROM ddr_b_excptn_item_day
100: WHERE excptn_typ = NVL(p_excptn_type,excptn_typ)
101: AND excptn_src_cd = NVL(p_excptn_src_code,excptn_src_cd)
102: AND day_cd <= TO_CHAR(p_end_date, 'YYYYMMDD');
103: COMMIT;