APPS.MSC_SCE_LOADS_PKG dependencies on MSC_CL_REFRESH_S

Line 5439: msde.last_refresh_number = msc_cl_refresh_s.nextval,

5435: SET msde.quantity = 0,
5436: msde.tp_quantity = 0,
5437: msde.primary_quantity = 0,
5438: msde.ref_header_id = p_header_id,
5439: msde.last_refresh_number = msc_cl_refresh_s.nextval,
5440: msde.last_update_login = G_DELETED
5441: WHERE msde.transaction_id = t_transaction_id(i);
5442:
5443: -- Disable all the corresponding serial Details

Line 8082: SET last_refresh_number = msc_cl_refresh_s.nextval,

8078:
8079: log_debug('At 2');
8080: FORALL j in t_line_id.FIRST..t_line_id.LAST
8081: UPDATE msc_sup_dem_entries
8082: SET last_refresh_number = msc_cl_refresh_s.nextval,
8083: ref_header_id = p_header_id,
8084: ref_line_id = t_line_id(j),
8085: quantity = round(nvl(t_quantity(j),0),6),
8086: tp_quantity = get_quantity(t_quantity(j), nvl(t_uom(j),'Ea'), tp_uom_code, inventory_item_id),

Line 8983: msc_cl_refresh_s.nextval,

8979: t_ins_container_type(i),
8980: t_ins_container_qty(i),
8981: t_ins_serial_number(i),
8982: t_ins_attach_url(i),
8983: msc_cl_refresh_s.nextval,
8984: t_posting_party_name(i),
8985: t_posting_party_id(i),
8986: p_user_id,
8987: sysdate,