APPS.MSC_CL_ITEM_PULL dependencies on MSC_ST_CATEGORY_SETS

Line 213: MSC_CL_PULL.v_table_name:= 'MSC_ST_CATEGORY_SETS';

209: -- bug 4365337
210: END IF;
211: COMMIT;
212:
213: MSC_CL_PULL.v_table_name:= 'MSC_ST_CATEGORY_SETS';
214: MSC_CL_PULL.v_view_name := 'MRP_AP_CATEGORY_SETS_V';
215:
216: v_sql_stmt:=
217: ' insert into MSC_ST_CATEGORY_SETS'

Line 217: ' insert into MSC_ST_CATEGORY_SETS'

213: MSC_CL_PULL.v_table_name:= 'MSC_ST_CATEGORY_SETS';
214: MSC_CL_PULL.v_view_name := 'MRP_AP_CATEGORY_SETS_V';
215:
216: v_sql_stmt:=
217: ' insert into MSC_ST_CATEGORY_SETS'
218: ||' ( SR_CATEGORY_SET_ID,'
219: ||' CATEGORY_SET_NAME,'
220: ||' DESCRIPTION,'
221: ||' CONTROL_LEVEL,'

Line 1667: delete from MSC_ST_CATEGORY_SETS st_item_category_set

1663: lv_end_date_active DATE;
1664: lv_deleted_flag PLS_INTEGER := 2;
1665: BEGIN
1666:
1667: delete from MSC_ST_CATEGORY_SETS st_item_category_set
1668: where st_item_category_set.sr_instance_id = MSC_CL_PULL.v_instance_id
1669: and st_item_category_set.SR_CATEGORY_SET_ID = -5000;
1670: commit;
1671: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');

Line 1688: insert into MSC_ST_CATEGORY_SETS (

1684:
1685: END ;
1686:
1687: IF lv_category_set_id = -5000 then
1688: insert into MSC_ST_CATEGORY_SETS (
1689: SR_CATEGORY_SET_ID,
1690: CATEGORY_SET_NAME,
1691: DESCRIPTION,
1692: CONTROL_LEVEL,