APPS.GMI_PURGE_EMPTY_BAL_PKG dependencies on IC_PURG_PRM

Line 17: FROM ic_purg_prm

13: ) IS
14:
15: CURSOR Cur_get_purg_info(l_criteria_id NUMBER) IS
16: SELECT *
17: FROM ic_purg_prm
18: WHERE criteria_id = l_criteria_id
19: AND process_ind = 1
20: AND delete_mark = 0;
21:

Line 57: /* Query the ic_purg_prm only if this package is called from the Purge Empty Balances FORM. */

53: BEGIN
54:
55:
56: /* 3377672 Purge Empty Balances Enh -- Added IF Condition */
57: /* Query the ic_purg_prm only if this package is called from the Purge Empty Balances FORM. */
58:
59: IF (p_criteria_id > 0) THEN
60: OPEN Cur_get_purg_info(p_criteria_id);
61: FETCH Cur_get_purg_info INTO l_purg_rec;

Line 205: /* Added IF Condition -- Update the ic_purg_prm only if it is called from Purge Empty Balances Form*/

201: END LOOP;
202: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
203:
204: /******** 3377672 Purge Empty Balances Enhancement - Start *********/
205: /* Added IF Condition -- Update the ic_purg_prm only if it is called from Purge Empty Balances Form*/
206:
207: IF (p_criteria_id > 0) THEN
208:
209: UPDATE ic_purg_prm

Line 209: UPDATE ic_purg_prm

205: /* Added IF Condition -- Update the ic_purg_prm only if it is called from Purge Empty Balances Form*/
206:
207: IF (p_criteria_id > 0) THEN
208:
209: UPDATE ic_purg_prm
210: SET run_date = sysdate,
211: process_ind = 2,
212: deleted_rowcount = l_del_count,
213: zero_rowcount = l_zero_count