APPS.MSC_CL_ITEM_PULL dependencies on MSC_ST_CATEGORY_SETS

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

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

Line 219: ' insert into MSC_ST_CATEGORY_SETS'

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

Line 1867: delete from MSC_ST_CATEGORY_SETS st_item_category_set

1863: lv_end_date_active DATE;
1864: lv_deleted_flag PLS_INTEGER := 2;
1865: BEGIN
1866:
1867: delete from MSC_ST_CATEGORY_SETS st_item_category_set
1868: where st_item_category_set.sr_instance_id = MSC_CL_PULL.v_instance_id
1869: and st_item_category_set.SR_CATEGORY_SET_ID = -5000;
1870: commit;
1871: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');

Line 1888: insert into MSC_ST_CATEGORY_SETS (

1884:
1885: END ;
1886:
1887: IF lv_category_set_id = -5000 then
1888: insert into MSC_ST_CATEGORY_SETS (
1889: SR_CATEGORY_SET_ID,
1890: CATEGORY_SET_NAME,
1891: DESCRIPTION,
1892: CONTROL_LEVEL,