APPS.ASL_INV_ITEM_SUMM_PUB dependencies on ASL_CATEGORY_SUMMARY_INFO

Line 160: DELETE asl_category_summary_info;

156: , x_err_code OUT NOCOPY VARCHAR2
157: ) IS
158: l_rows_inserted NUMBER := 0;
159: BEGIN
160: DELETE asl_category_summary_info;
161: INSERT INTO asl_category_summary_info (CATEGORY_ID, CATEGORY_SET_ID , ORGANIZATION_ID,
162: CREATION_DATE, LANGUAGE_CODE )
163: SELECT DISTINCT category_id, category_set_id , organization_id, SYSDATE, language_code
164: FROM asl_inventory_item_denorm ;

Line 161: INSERT INTO asl_category_summary_info (CATEGORY_ID, CATEGORY_SET_ID , ORGANIZATION_ID,

157: ) IS
158: l_rows_inserted NUMBER := 0;
159: BEGIN
160: DELETE asl_category_summary_info;
161: INSERT INTO asl_category_summary_info (CATEGORY_ID, CATEGORY_SET_ID , ORGANIZATION_ID,
162: CREATION_DATE, LANGUAGE_CODE )
163: SELECT DISTINCT category_id, category_set_id , organization_id, SYSDATE, language_code
164: FROM asl_inventory_item_denorm ;
165:

Line 176: p_table => 'ASL_CATEGORY_SUMMARY_INFO'

172: x_err_code := '0';
173: END IF;
174: IF G_DEBUG = 'Y' THEN
175: asl_summ_load_glbl_pkg.Write_Log(
176: p_table => 'ASL_CATEGORY_SUMMARY_INFO'
177: , p_action => 'I'
178: , p_procedure => 'Category_summary_Info_Refresh'
179: , p_num_rows => l_rows_inserted
180: );

Line 190: p_table => 'ASL_CATEGORY_SUMMARY_INFO'

186: x_err_code := '2';
187:
188: IF G_DEBUG = 'Y' THEN
189: asl_summ_load_glbl_pkg.Write_Log(
190: p_table => 'ASL_CATEGORY_SUMMARY_INFO'
191: , p_action => 'E'
192: , p_procedure => 'Category_summary_Info_Refresh'
193: , p_load_mode => 'I'
194: , p_message => x_err_msg