APPS.IGI_IMP_IAC_PURGE_PKG dependencies on IGI_IMP_IAC_INTERFACE_CTRL

Line 32: FROM IGI_IMP_IAC_INTERFACE_CTRL

28: BEGIN
29:
30: SELECT COUNT(*)
31: INTO V_COUNT
32: FROM IGI_IMP_IAC_INTERFACE_CTRL
33: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
34: AND TRANSFER_STATUS = 'C';
35:
36: IF V_COUNT = 0 THEN

Line 41: FROM IGI_IMP_IAC_INTERFACE_CTRL

37:
38: IF p_category_id IS NOT NULL THEN
39: SELECT count(*)
40: INTO category_count
41: FROM IGI_IMP_IAC_INTERFACE_CTRL
42: WHERE BOOK_TYPE_CODE = p_book_type_code
43: AND CATEGORY_ID <> p_category_id;
44:
45: IF p_asset_id IS NOT NULL THEN

Line 68: DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL

64:
65: DELETE FROM IGI_IMP_IAC_INTERFACE
66: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
67:
68: DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL
69: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
70:
71: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
72: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line 82: DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL

78:
79: DELETE FROM IGI_IMP_IAC_INTERFACE
80: WHERE CATEGORY_ID = p_category_id;
81:
82: DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL
83: WHERE CATEGORY_ID = p_category_id;
84:
85: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
86: WHERE CATEGORY_ID = p_category_id;