APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_LOCATION_ID_S

Line 8273: SET sr_tp_site_id = msc_st_location_id_s.NEXTVAL

8269: IF c7%ROWCOUNT > 0 THEN
8270: v_sql_stmt := 31;
8271: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8272: UPDATE msc_st_trading_partner_sites
8273: SET sr_tp_site_id = msc_st_location_id_s.NEXTVAL
8274: WHERE rowid = lb_rowid(j);
8275:
8276: -- Insert record in LID
8277: v_sql_stmt := 32;

Line 9250: SET location_id = msc_st_location_id_s.NEXTVAL

9246: IF c14%ROWCOUNT > 0 THEN
9247: v_sql_stmt := 43.1;
9248: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9249: UPDATE msc_st_location_associations
9250: SET location_id = msc_st_location_id_s.NEXTVAL
9251: WHERE rowid = lb_rowid(j);
9252:
9253: -- Insert record in LID
9254: v_sql_stmt := 43.2;

Line 15149: SET location_id = msc_st_location_id_s.NEXTVAL

15145:
15146: IF c7%ROWCOUNT > 0 THEN
15147: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15148: UPDATE msc_st_region_locations
15149: SET location_id = msc_st_location_id_s.NEXTVAL
15150: WHERE rowid = lb_rowid(j);
15151:
15152: -- Insert record in LID
15153: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST