APPS.DELETE_FROM_IREP dependencies on FND_FORM_FUNCTIONS

Line 80: from FND_FORM_FUNCTIONS

76: Delete from FND_LOOKUP_ASSIGNMENTS
77: where obj_name = 'FND_IREP_FUNCTION_FLAVORS'
78: and INSTANCE_PK1_VALUE in
79: (select function_id
80: from FND_FORM_FUNCTIONS
81: where irep_class_id = key_id);
82:
83: Delete from FND_CHILD_ANNOTATIONS
84: where parent_flag = 'F'

Line 87: from FND_FORM_FUNCTIONS

83: Delete from FND_CHILD_ANNOTATIONS
84: where parent_flag = 'F'
85: and parent_id in
86: (select function_id
87: from FND_FORM_FUNCTIONS
88: where irep_class_id = key_id);
89:
90: Delete from FND_PARAMETERS
91: where function_id in

Line 93: from FND_FORM_FUNCTIONS

89:
90: Delete from FND_PARAMETERS
91: where function_id in
92: (select function_id
93: from FND_FORM_FUNCTIONS
94: where irep_class_id = key_id);
95:
96: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Function Sub-Entities Removed');

Line 117: from FND_FORM_FUNCTIONS

113: -- remove flavors
114: Delete from FND_IREP_FUNCTION_FLAVORS
115: where FUNCTION_ID in
116: (select function_id
117: from FND_FORM_FUNCTIONS
118: where irep_class_id = assoc_key_id);
119:
120: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Function Flavors Removed');

Line 125: Delete from FND_FORM_FUNCTIONS_TL

121: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Function Flavors Removed');
122: end if;
123:
124: --remove functions
125: Delete from FND_FORM_FUNCTIONS_TL
126: where function_id in
127: (select function_id
128: from fnd_form_functions
129: where irep_class_id = assoc_key_id);

Line 128: from fnd_form_functions

124: --remove functions
125: Delete from FND_FORM_FUNCTIONS_TL
126: where function_id in
127: (select function_id
128: from fnd_form_functions
129: where irep_class_id = assoc_key_id);
130:
131: Delete from FND_FORM_FUNCTIONS
132: where irep_class_id = assoc_key_id;

Line 131: Delete from FND_FORM_FUNCTIONS

127: (select function_id
128: from fnd_form_functions
129: where irep_class_id = assoc_key_id);
130:
131: Delete from FND_FORM_FUNCTIONS
132: where irep_class_id = assoc_key_id;
133:
134: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Derived Functions Removed');

Line 163: from FND_FORM_FUNCTIONS

159: -- remove flavors
160: Delete from FND_IREP_FUNCTION_FLAVORS
161: where FUNCTION_ID in
162: (select function_id
163: from FND_FORM_FUNCTIONS
164: where irep_class_id = key_id);
165:
166: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Function Flavors Removed');

Line 171: Delete from FND_FORM_FUNCTIONS_TL

167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Function Flavors Removed');
168: end if;
169:
170: --remove functions
171: Delete from FND_FORM_FUNCTIONS_TL
172: where function_id in
173: (select function_id
174: from fnd_form_functions
175: where irep_class_id = key_id);

Line 174: from fnd_form_functions

170: --remove functions
171: Delete from FND_FORM_FUNCTIONS_TL
172: where function_id in
173: (select function_id
174: from fnd_form_functions
175: where irep_class_id = key_id);
176:
177: Delete from FND_FORM_FUNCTIONS
178: where irep_class_id = key_id;

Line 177: Delete from FND_FORM_FUNCTIONS

173: (select function_id
174: from fnd_form_functions
175: where irep_class_id = key_id);
176:
177: Delete from FND_FORM_FUNCTIONS
178: where irep_class_id = key_id;
179:
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Functions Removed');