APPS.IGI_IMP_IAC_PURGE_PKG dependencies on IGI_IMP_IAC_INTERFACE

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 48: FROM IGI_IMP_IAC_INTERFACE

44:
45: IF p_asset_id IS NOT NULL THEN
46: SELECT count(*)
47: INTO asset_count
48: FROM IGI_IMP_IAC_INTERFACE
49: WHERE BOOK_TYPE_CODE = p_book_type_code
50: AND CATEGORY_ID = p_category_id
51: AND ASSET_ID <> p_asset_id;
52: ELSE

Line 65: DELETE FROM IGI_IMP_IAC_INTERFACE

61:
62: DELETE FROM IGI_IMP_IAC_CONTROLS
63: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
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;

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 71: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD

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;
73:
74: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
75: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line 79: DELETE FROM IGI_IMP_IAC_INTERFACE

75: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
76:
77: ELSIF category_count > 0 AND asset_count = 0 THEN
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;

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;

Line 85: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD

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;
87:
88: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
89: WHERE CATEGORY_ID = p_category_id;

Line 93: DELETE FROM IGI_IMP_IAC_INTERFACE

89: WHERE CATEGORY_ID = p_category_id;
90:
91: ELSE
92:
93: DELETE FROM IGI_IMP_IAC_INTERFACE
94: WHERE ASSET_ID = p_asset_id;
95:
96: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
97: WHERE ASSET_ID = p_asset_id;

Line 96: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD

92:
93: DELETE FROM IGI_IMP_IAC_INTERFACE
94: WHERE ASSET_ID = p_asset_id;
95:
96: DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
97: WHERE ASSET_ID = p_asset_id;
98:
99: DELETE FROM IGI_IMP_IAC_INTERMEDIATE
100: WHERE ASSET_ID = p_asset_id;