APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_LOCATION_ID_S

Line 8303: SET sr_tp_site_id = msc_st_location_id_s.NEXTVAL

8299: IF c7%ROWCOUNT > 0 THEN
8300: v_sql_stmt := 31;
8301: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8302: UPDATE msc_st_trading_partner_sites
8303: SET sr_tp_site_id = msc_st_location_id_s.NEXTVAL
8304: WHERE rowid = lb_rowid(j);
8305:
8306: -- Insert record in LID
8307: v_sql_stmt := 32;

Line 8422: SET location_id = msc_st_location_id_s.NEXTVAL

8418: IF c15%ROWCOUNT > 0 THEN
8419: v_sql_stmt := 32.3;
8420: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8421: UPDATE msc_st_trading_partner_sites
8422: SET location_id = msc_st_location_id_s.NEXTVAL
8423: WHERE rowid = lb_rowid(j);
8424:
8425: -- Insert record in LID
8426: v_sql_stmt := 32.4;

Line 9376: SET location_id = msc_st_location_id_s.NEXTVAL

9372: IF c14%ROWCOUNT > 0 THEN
9373: v_sql_stmt := 43.1;
9374: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9375: UPDATE msc_st_location_associations
9376: SET location_id = msc_st_location_id_s.NEXTVAL
9377: WHERE rowid = lb_rowid(j);
9378:
9379: -- Insert record in LID
9380: v_sql_stmt := 43.2;

Line 18636: SET location_id = msc_st_location_id_s.NEXTVAL

18632:
18633: IF c7%ROWCOUNT > 0 THEN
18634: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
18635: UPDATE msc_st_region_locations
18636: SET location_id = msc_st_location_id_s.NEXTVAL
18637: WHERE rowid = lb_rowid(j);
18638:
18639: -- Insert record in LID
18640: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST